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. 

Please note there are two options below to generate the report. The first set of instructions is the standard report. If a P-Card holder is listed as the Vendor in the accounting software and you want the true Merchant listed in AssetHub, use the second set of instructions.

[Option 1] Exporting the Asset Report without the Merchant Field Included

  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 All Data (CTRL+9) (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.

[Option 2] Exporting an Asset Report with the Merchant Field Included

If your production is using P-Cards and you want to map the SmartAccounting Merchant to the Vendor field in AssetHub rather than list the P-Card holder as the Vendor, use the following instructions. If you do not see this report option in SmartAccounting, request access through your SmartAccounting Account Manager.

  1. To export your report from SmartAccounting, click Reports on the left navigation menu to enter the Reports module.
  1. Click the L - Ledger Reports tab. 
  1. Select Asset Disposition Reports from the Report Group dropdown.
  2. Select AD 530 AssetHub Excel File from the Report dropdown.
  1. Select your currency. You must run a separate report for each currency.
  1. Click the Export All Data (CTRL+9) button on the top navigation bar and save the report to your computer as an Excel Workbook (.xlsx).
  1. After saving the ledger, filter the Excel file to show only Asset transactions. Delete all other transactions and save your updated file.
  2. Your file is now ready to upload to AssetHub.
    1. If this is the first ledger upload, please send the file to your AssetHub Account Manager who will handle the upload.

How did we do?

Locking Currencies

Exporting Asset Reports from Global Vista