AR & AP Reporting
Orders scheduled in the laybook (installation date) for builders on the list. Excludes orders already marked Invoiced.
Generate Report
Job Costed (non-list) report
Orders that are Job Costed in RFMS with an outstanding balance and are not on the Builders/Customers list. Same columns as above.Retail balance — upcoming install week
Installs scheduled for the next Monday–Sunday where a retail customer (not a builder on the list) still owes money. Includes retail invoices linked via a builder's billing group. Runs automatically every Monday 6:00 AM.
Automatic AR report (builders): Every Thursday at 4:00 AM laybook and job-costed reports run and are emailed to accounts@atozflooringsolutions.com.au. Default date range is up to 4 weeks back. Only builders on the reporting list are included. Configure dates and sort in the Configure automatic reporting tab — this does not apply to supplier EOM below.
EOM supplier statement reconciliation
Suppliers only — compares harvested supplier PDF statements to Xero aged payables for the selected month. On the 4th of each month at 6:00 AM the app automatically fetches the Xero AP report and collects any missing supplier statements from email. Use Get AP Report to refresh manually, then reconcile when sync is complete.
Automatic supplier run: 4th of month, 6:00 AM (Brisbane) — Xero AP fetch, then missing supplier statement harvest only. Reconciliation (Step 3) is always manual — it does not start when Get AP Report finishes. Email reports cover suppliers on the master list with open Xero payables only.
Working…
Step 1
Step 2 — Sync status
Updates after Step 1 — fetch Xero + check for missing statements (not reconciliation).
Step 3
Working…
0%
Supplier monthly average spend
Flooring suppliers from the Xero/RFMS master list — average monthly ACCPAY spend from Xero, with ABN. Choose lookback, date basis, and whether to show on screen, export CSV, or both.
Payment basis needs
accounting.payments.read in Xero
Leave blank for last complete month
Builders / Customer Reporting IDs
Only orders for these builders are included in reports. This list is maintained here only—add, remove, or import from this tab.Add entries above or import from Excel (.xlsx) or CSV (columns: name, customer ID).
| Name | Customer ID |
|---|
Configure automatic reporting
Accounts team can edit these settings. The automatic report runs every Thursday at 4:00 AM and is emailed to accounts@atozflooringsolutions.com.au.
Default 4 weeks. Applies to both automatic reports when active.
Automatic reports (each can be turned on or off):
When active, include these views in the email (tick all that apply):
At least one view must be active. If none selected, Date order is used.
When active, a second email is sent: orders that are Job Costed with balance and are not on the Builders/Customers list.