ReportsThis accounts receivable workbench created in Excel uses both the financial and operational formulas to pull the necessary data directly from the SyteLine database to reconcile the A/R control account.
Drill DownSelect SS Drill Down from the menu to see the aging details for a particular customer. With this drill down we have drilled down to the A/R details for the selected customer.
Automate your spreadsheet experience and remove the risk of data error with manual manipulation and consolidation. Shave hours, if not days, down to minutes with a click of a button. Data that you’re pulling out of your ERP system manually or with an upload from another data file should be automated.
The images to the right illustrate one of our operational efficiency workbenches. At month end in SyteLine, the accounting department will reconcile the five control accounts; i.e., A/R, A/P, V/P, Inventory and WIP. This particular workbench zeros in on accounts receivable.
The steps to reconcile manually are to run the accounts receivable aging report, run the general ledger by account report, and manually tie the two reports. If they are out of balance, go to additional screens and possibly run additional reports to reconcile the difference.
With this analytic, with one push of the button, the aging data is returned, the general ledger data is returned, and the journal data is available to see if anything was left un-posted. Remember, this is all presented cleanly within the familiar environment of Microsoft Excel.