Use the accounting export to review issued Invoice lines or recorded payments outside Jobsworth. You need access to financial exports and the records included in the file.
1. Open the export
Open a report in Reports, then choose Export CSV from Report actions. The Export accounting data window keeps the selection and its preview together.
Choose an Export type:
- Invoice lines includes issued and paid Invoices by issue date, with one row for each saved line.
- Money received includes recorded transactions by the date received in your Business time zone. This choice requires access to payments.
2. Choose the period and records
- Set From date and To date. Both dates are included.
- For Invoice lines, choose whether to Include cancelled issued Invoices.
- Check the Site or the applied Invoice report filters.
- Under Fields, select the columns you need. All fields are selected initially.
An Invoice report passes its applied filters into the export, including its search and selected group. Unrun changes do not carry over. Use Clear Report Filters if you want to choose the export’s Site separately.
Money received uses its own period and Site, rather than the Invoice report’s filters.
3. Review the preview
The preview updates automatically when you change the selection. Wait for it to finish, then check the record count, CSV row count and totals.
Open Preview rows and totals to inspect the sample and date basis. The sample is only part of the file. The counts and totals describe the whole selection, including matching records beyond the visible report page.
Open File layout and field guide for the column definitions. You can keep a copy using Download Help Article.
4. Download the file
Choose Download CSV. When Jobsworth shows Download started, check your browser’s downloads for the file.
Downloading does not alter an Invoice or record a payment. The CSV is a generic accounting file; check its fields against the requirements of the system you intend to use it with.
If the export cannot be downloaded
Use the displayed error to review your selection. Narrow the period if the selection is too large. If records changed since the preview, let Jobsworth prepare the updated preview and check it before downloading again.
Keep the same Business selected while the download is being prepared. Check your downloads before repeating an export that has already started.