Skip to main content

Exporting Your Financial Data

Julia Rose avatar
Written by Julia Rose
Updated over 12 months 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?