Invoices: Exporting data

[JackTapestrySupport]

In this tutorial, we’re going to be looking at the Invoice Data Export screen.

This screen compiles data from the invoicing part of our Management System into a CSV file. There’s a few different options and formats which we’ll go through now.

Firstly, to find this screen just click “Booking” (1) ->  “Exports” (2) -> “Invoice Data Export” (3).

 

 

Here you will see the data export screen; it has 3 sections you can use to customise what data is included on your CSV.

The first section is the Date Range.

By default this will be the month we’re currently in, but you can change the month simply by clicking it (1). You can also set your own custom date range by clicking the “Use Custom Date Range” button (2).

 

 

The custom date range option allows you to choose any start and end date.

 

 

The second section is Children.

Here you can choose to export data for all children:

 

 

Or for children in a specific room:

 

 

And finally, for one specific child.

 

 

The last section is Format.

You have two options here; “Invoices” (1) and “Invoice Summary Lines” (2).

 

 

The first option gives you one line per invoice on your CSV. It will show the following data for invoices within date range you have chosen, for the child(ren) you have chosen.

1. Invoice number
2. Invoice date
3. Due date
4. Period from
5. Period to
6. Child’s name
7. Amount
8. Invoice status
9. Payment Status
10. Notes

It will look something like this:

 

 

The second option, “Invoice Summary Lines”, will give you more detail on the specific charges within the invoice; it will show you the individual charges within the same invoice.

For example, if an invoice has charges for Regular Schedule Bookings, Extra Charges, Extra Bookings or Refunds this will be shown on the Summary Line Item column.

It will look something like this:

 

 

Once you're happy with all the format options, just click "Generate CSV" at the bottom.

 

 

So that’s how you export your invoice data. If you have any questions, please email us at customer.service@eyfs.info.

 

 

 

 

Go back to Main Tutorials Page