Blog Post

Our Favorite Reports in Acumatica

Published on

September 10, 2020

By

by

Dana Zodrow

Reports are a necessary tool when completing accounting tasks.  Not only are reports necessary to reconcile accounts, they also provide information to Executive Staff so that sound financial decisions are made.

Here are some of our favorite reports in Acumatica:

Trial Balance

  • I use the trial balance report every week.  It’s a quick way to look at account balances and take care of anything out of the ordinary quickly.
  • To get to the report do the following
  • In the Finance module, click on Trial Balance Detailed (I use detailed so I can see all accounts/subaccounts, use Trial Balance Summary if you do not need the additional information)
  • Choose the Report Parameters
  • Company
  • Branch (if applicable)
  • Ledger (ledger name in Acumatica)
  • Financial Period (month and year)
  • Click Run Report
  • Click on the account (in blue) to quickly look at the details
  • Export if needed to Excel or PDF by click Export then the format needed
  • Print if needed
  • I hardly ever need to export or print the report since you are able to get to the information easily right from the report.  In fact I have never worked with another software that had this ability!

AR Aged Period Sensitive

  • I use this report for collection as well as balancing to the G/L monthly
  • In the Receivables Module
  • Click AR Aged Period Sensitive
  • Choose the Report Parameters
  • Report Format:  Detailed or Summary (totally your preference)
  • Company
  • Branch if applicable
  • Financial Period
  • Customer Class, if necessary, I leave blank to obtain all customers with a balance
  • Print, Send or Export according to what you need
  • You will be able to get to the customer itself or an invoice/credit memo directly from the report using the blue links


AP Aged Period Sensitive

  • I also use this report to verify past due amounts or clean up as well as balancing to the G/L monthly
  • In the Payables module, click AP Aged Period Sensitive
  • Report Format:  Detailed or Summary (totally your preference)
  • Company
  • Branch if applicable
  • Financial Period
  • Vendor Class, if necessary, I leave blank to obtain all vendors with a balance
  • Print, Send or Export according to what you need
  • Again, you will be able to get to the vendor itself or a bill/debit adjustment directly from the report using the blue links

Financial Statements

  • After all accounts are reconciled for the previous month, I export the following reports for the President
  • Profit & Loss
  • Balance Sheet
  • Income Statement
  • All reports are in the Finance module and can be printed, exported or sent according to your company’s preference.

Though Acumatica has many reports available, I do not need to use many because Acumatica is so user friendly and there are multiple ways to retrieve information.  These are only a list of my favorite reports that I use on a continuous cycle. 


Written By
Website Proudly Crafted by DSB Creative