In this article:
|
If you do your accounting outside of the app, you can export your data as a CSV file.
Export Your Invoicing Data
When you export your Attendance data, you will be able to choose between a few options:
Invoices
Invoice lines and
Invoice items
Each of these reports will provide you with slightly different datasets. The outputs will be outlined below.
Invoices
To export your invoicing data:
Log in to the app and click Finances in your sidebar
Click on Reports
Click on Invoices
Click Export CSV
Click Invoices in the dropdown
A new window will open showing your latest exported files.
Click Download and the CSV will download to your computer:
The invoices download includes the following information:
Invoice date
Due date
Created date
Invoice number
Nursery name
Bill payer ID
Bill payer name
Billing reference number
Customer reference number
Child name
Total amount on invoice
Note
Cost Centre
Type (whether the entry is an invoice or a credit note/other)
Status (whether the invoice has been cancelled)
Please note, not all columns will be populated!
Invoice lines
Downloading invoice lines will give you a more detailed report of the contents of your invoices. This report will generate a report that shows:
The date range you're downloading from (From → To)
Type (whether the line includes an item that's part of a booking plan or an ad-hoc purchase, credits, deposit returns, and custom lines)
Line ID
Line child ID
Line total
Line note
Invoice date
Due date
Created date
Invoice number
Nursery name
Bill payer ID
Bill payer name
Billing reference number
Customer reference number
Child name
Total amount
Note
Cost centre
Type
Status
Invoice items
You will be able to download a report of invoice items if you are using our Improved Actuals invoicing method. The invoice items report includes information such as:
Item ID
Item type
Title
Line ID
Amount invoiced
Item total
Line note
Invoice date
Due date
Created date
Invoice number
Nursery name
Bill payer ID
Bill payer name
Billing reference number
Customer reference number
Child ID
Child name
Invoice total
Invoice note
Cost center
Status
Pricing group
Export your bill payers
To export all of your bill-payers' data:
Log in to the app and click Finances
Click on Reports
Click on Bill Payers
Click Generate CSV
After a few seconds, the button will change to say Download as CSV
Click on this and the CSV will download to your computer:
Note: Future invoice lines are the part of already created invoices that are greater than the as-of date used when exporting the report
For example, if you invoice November 1st to November 30th and pull a report As-Of November 15th, you would see the November 15th to November 30th as Future Invoice Lines
The full value would be included in the full balance - so the future invoice lines is just the subset of the total owed balance which is later than the as-of date
Export your revenue data
To export your revenue data:
Log in to the app and click Finances
Click on Reports
Click on Revenue
Ensure the Refresh Data button (found above the graph) has been clicked recently
Click Download as CSV and the CSV will download to your computer:
Uploading the data to my accounting software
For help with uploading your data to your accounting software, we encourage you to visit their own help centres:
I need more help: |