Accounting Link - Reports for reconciling your data
This report is designed for the legacy Accounting Link integration (and not for cloud-based Xero and MYOB Integrations). Please refer to the Accounting Integration Overview article for details on supported integrations.
Retail Express includes a variety of reports available to use for the initial reconciliations to your accounting data file.
Profit & Loss Accounts
| Information |
Report |
| Sales and GST, Freight Collected and CR movements in Gift Voucher Liability Account |
Reports > Accounting Link Reconciliation Reports > Accounting Basis Reconciliation Report > Filters as per your Accounting Basis selected in Accounting Link |
| COGS/Inventory reducing movements | Reports> Accounting Link Reconciliation Reports > Accounting Basis Reconciliation Report for desired period > Use the Cost of Sales Ex column on the far right of the report |
| Stock Adjustments | Reports > Stock Reports >Stock Adjustment Reports for desired period |
| Discrepancies |
To investigate any discrepancies compare these reports to the reports generated by Accounting Link & the Data Download (details of transactions uploaded to your accounting data by Accounting LInk). To find the feature:
|
Balance Sheet Accounts
Please be aware that all Retail Express Accounting Link Reports are currently dynamic therefore you are unable to complete retrospective reporting.
Important: To obtain the correct figures the report will need to run at the close of business on the day you require the balance and saved.
| Information |
Report |
| Inventory Account |
Reports > Stock Reports >Stock Value vs Sales (must be after all transactions have ceased for the day) > Save report to excel |
| Inventory Increases | Reports > Accounting Link Reconciliation Reports > Purchasing Reconciliation Report for desired period |
| Accounts Receivable |
Reports > Accounting Link Reconciliation Reports >Account Customer Reconciliation Report > Select “Ignore date from” and the current date as end date (must be after all transactions have ceased for the day) > Save report to excel |
| Layby Liability Account |
Reports > Accounting Link Reconciliation Reports > Layby Reconciliation Report > Select “Ignore date from” and the current date as end date (must be after all transactions have ceased for the day) > Save the report to excel |
| Gift Voucher Liability Account |
Reports > Finance Reports > Voucher Creation Report (must be after all transactions have ceased for the day) > Save report to excel |
Debtor Related
| Report | Reports Menu Path | Description |
| Account Customer Reconciliation Report | Accounting Reports > Account Customer Reconciliation Report |
Allows you to view your Debtors (Account Customers) and the details of their Sales - Total Sales, Total Paid, Balance Due and Paid during the Period selected Important: Ensure to tick "Ignore Date From" and set the "Date To" to todays date to capture all data. |
| Layby Reconciliation Report | Accounting Reports > Layby Reconciliation Report |
Displays non-account customers sales that are an "Awaiting Payment" status that have had a payment made up until the DateTo and are not completely fulfilled. Important: Ensure to tick "Ignore Date From" and set the "Date To" to todays date to capture all data. |