Table of Contents

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. 

Using SmartAccounting Version 1.9.30 or Later

Note: If your production has not updated to the most current SmartAccounting software (or at least version 1.9.30, Service Pack 12), please contact SmartAccounting Support.
  1. To export your Asset report from SmartAccounting, go to the L-Ledger Reports tab in Reports.
  2. In the Report Group dropdown at the top of the page, select Asset Disposition Reports.
  3. In the Report dropdown, select Asset Hub Excel File.
  4. Choose one currency in the dropdown menu. If your production uses multiple currencies, you must run a separate report for each currency.
  5. On the ribbon at the top of the page, click Export to Excel 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.

Using Older Versions of SmartAccounting

  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