How to download accountant reports from JobSheet
Steps
- Open Reports from the sidebar or More menu.
- Under Period, pick the range you need: This month, Tax year, This quarter, Last 30 days, Last 90 days, All time, or Custom range (set From and To dates).
- Wait for the summary and funnel to load for that period.
- Scroll to Exports.
- Under Register / lines period by, leave the default Issued date (VAT period) unless your bookkeeper asks for Last updated or Paid date.
- Download the files your bookkeeper needs:
- Summary CSV: matches on-screen counts and GBP totals (including Net money in after credit notes)
- Invoice register (accountant): one row per invoice or credit note; includes
document_type, link to source invoice for credit notes, net/VAT/gross, optional payment reference and payment method - Quote register: one row per quote in the period
- VAT period (MTD prep): issued invoices and credit notes in the period — credit notes appear as negative net/VAT/gross rows with source invoice number; proforma excluded; footer totals net credits
- Invoice lines (accountant): one row per line item for sent/paid invoices and credit notes (signed amounts for ledger import)
Register vs VAT period
| Export | Best for | Date basis |
|---|---|---|
| Invoice register | Year-end document listing, audit samples | Last updated in period (default) |
| VAT period | VAT return prep | Issued date of sent/paid docs |
| Invoice lines | Xero/Sage line import | Same as VAT period (sent/paid, issued filter) |
Credit notes in exports
- Credit notes reduce Net money in on the summary for the period they were issued.
- VAT period CSV includes credit note rows with negative amounts,
source_invoice_number, and customer. - Invoice register includes
credited_invoice_idand source invoice number for traceability. - On Reports, use Register / lines period by to filter the invoice register and invoice-lines export by last updated, Issued date (VAT period) (default), or paid date.
JobSheet + Xero / Sage
JobSheet is the sales document source — not your general ledger. Export CSV from Reports, import or journal in Xero/Sage, then reconcile to bank feeds in your accounting software.
Tips
- Money in (marked paid) and Waiting to be paid on the summary reflect invoice statuses you set in JobSheet, not bank reconciliation.
- Enable UK VAT in Workspace for meaningful VAT column splits on exports.
- Optional Payment reference (optional) and Payment method (Bank transfer, Card, Cash, Cheque, Other) when marking an invoice paid appear on the invoice register.
- For a quick snapshot without exports, Dashboard shows today’s activity and KPI counts.