Jump to content
Home
Forum
Articles
About Us
Tapestry
This is the EYFS Staging Site ×

Invoices: Exporting data


Recommended Posts

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).

 

2023-12-11_09-46-51.png

 

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).

 

2023-12-11_09-48-05.png

 

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

 

2023-12-11_09-51-49.png

 

The second section is Children.

Here you can choose to export data for all children:

 

2023-12-11_09-52-26.png

 

Or for children in a specific room:

 

2023-12-11_09-52-46.png

 

And finally, for one specific child.

 

2023-12-11_09-54-22.png

 

The last section is Format.

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

 

2023-12-11_09-54-42.png

 

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:

 

image.png

 

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:

 

image.png

 

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

 

2023-12-11_09-55-15.png

 

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

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. (Privacy Policy)