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.
