Exporting Your Financial Data
Julia Rose avatar
Written by Julia Rose
Updated over a week ago

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:

Did this answer your question?