Billing overview and reports
Read the Billing overview, the invoice register, the tax bridge, the correction chain and the instalments report.
Before you begin
- You need billing.view.
- The reports with dates default to 1 January this year to today. Change From and To to the period you want.
- Amounts are in the company currency (AED) unless a column says otherwise.
Billing overview
Open Billing > Overview. It shows today's position:
- Six figures with the change over the last 7 days: sales orders to invoice, draft invoices, waiting for approval, overdue receivables (and due this week), matching exceptions and refunds pending. Each opens the list behind it.
- A billing trend by month: invoiced, credits and collected.
- Receivables aging in days past due.
- The approval queue with age.
- Exceptions requiring action, such as 'Duplicate supplier reference' (a draft bill repeating a posted supplier invoice number) and 'Missing tax treatment' (a draft line with no tax code).
- Collections and refunds, and recent billing activity, which can be exported.
The period selector (this month, last month, this quarter, this year) changes the recent-activity list; the figures stay "as of today". Press Refresh to reload, View all to open a list and View invoice register for the register.
Invoice register
Open Billing > Reporting > Invoice register. It lists posted documents in the period, less notes.
- Choose Sales or Purchases at the side.
- Set From and To.
- Read each row: Number, Kind, Date, Partner, Original, Status, Currency, Net, Tax, Total and Signed. You can show the hidden columns Supply date and Home.
Net plus tax equals total on each row, and credit notes are negative in the Signed column. Example: an invoice of 1,050.00 and its credit note of 210.00 give net 800.00, tax 40.00 and total 840.00, and the report says it reconciles.
Tax bridge
Open Billing > Reporting > Tax bridge. It compares the tax on the register with the movement on the output and input tax accounts in the ledger, and shows a difference.
- With only invoices posted, the output side difference is 0.00 and the report says it reconciles.
- If someone posts a manual journal of AED 100.00 to the output VAT account, the difference is 100.00 and it says it does not reconcile. That is tax posted outside invoices, and you should investigate it before filing your VAT return.
- A second table shows register tax by tax code.
Correction chain
Open Billing > Reporting > Correction chain. It lists notes against their originals: Note, Kind, Date, Partner, Reason, Original, Original total, Credited so far, This note and Refunded. The control line confirms that notes never exceed the original.
Instalments due
Open Billing > Reporting > Instalments due (only when the Instalment feature is on). It lists open instalments and offers Hand overdue to collections. See Instalments and collections.
What happens next
Reports read data on request and change nothing, except the collections hand-off.
Good to know
- Each report shows a reconciliation line. If it says it does not reconcile, find the difference before relying on the figures.
- A date typed in the wrong format is refused: 'Send the date as YYYY-MM-DD.'
- The To invoice list is capped at 300 open orders and can be slow with a very large backlog.
- You see only the company you are working in. Another company's documents are not found.