Exporting Asset Reports from SmartAccounting

Jennifer Sneider Updated by Jennifer Sneider

This article guides accountants using SmartAccounting through running and saving an Asset report in the correct format so they can import their ledger into Asset Hub. 

  1. To export your Asset report from SmartAccounting, go to the L - Ledger Reports tab in Reports. 
  2. Verify the following fields are completed as outlined below:
  • A Report Group - Ledger Lists
  • B Report - General Ledger Detail by Account
  • C Free Field(s) - Select the codes designating your Assets (A, I, M)
  • D Transaction Type(s) to Exclude - PO, PR, PRI
  • E Exclude Balance Sheet Accounts - ✔️
  • * Currency - Run a separate report for each currency
  1. If everything is correct, click Export to Excel (F) and save the report to your computer as an Excel Workbook (.xlsx).
Pro tip: If your production is making purchases in multiple currencies and this is the first time this project is uploading a ledger (Asset Report) into Asset Hub, be sure to Lock Currencies before Uploading the SmartAccounting Ledger.

How did we do?

Matching Columns

Exporting Asset Reports from Global Vista

Contact