Exporting invoices and payments for your bookkeeper

Download a period of invoices and payments as an Excel workbook or a CSV, ready for your treasurer, your bookkeeper or a Xero import, instead of saving invoices one PDF at a time.

On this page

Before you start

Export a period

  1. Open Finances → Invoices & Receipts or Finances → Transactions.
  2. Click Export at the top of the page. Both pages open the same dialog; the only difference is which dataset starts ticked.
  3. Set the From and To dates. Both are required, and the range can be up to 400 days: a financial year fits, a longer span has to be exported in parts. The dialog opens on the last 90 days, or on the dates you already had the page filtered to.
  4. Choose what to include:
    • Invoices: one row per invoice, with what has been paid and what is still owing
    • Payments and receipts: one row per payment taken, with refunds netted off
  5. Tick the statuses you want. Ticking none exports every status, so a cancelled or written-off record still appears in the audit trail.
  6. Tick the columns you want. Every column is a tick box, with sensible ones already ticked. Each column list (invoice columns, receipt columns) has its own Select all and Reset.
  7. Choose the file format:
    • Excel, for a treasurer who will open and total it: amounts arrive as numbers with a filter row on top, not as text. Tick both datasets and the workbook carries a worksheet each.
    • CSV, for feeding another system. A CSV holds one table, so it carries invoices or receipts, not both.
  8. Click Export in the dialog, and the file downloads.

Export for a Xero import

Switch Layout from Your own data to Xero sales invoices import and the file comes out in Xero's own layout instead of yours: a fixed header row Xero recognises, one line per invoice.

  • It is invoices only and always a CSV, because Xero takes payments through a separate import.
  • Choose "Tax Exclusive" when you import it. The amount on each line is the GST-exclusive subtotal, with the GST stated beside it. Importing it as Tax Inclusive posts the GST twice.
  • The account code is yours to supply. Type your revenue account code into the dialog and every line carries it. Leave it blank and Xero asks for one at import; Horsify doesn't know your chart of accounts and won't guess it.
  • Cancelled, written-off and draft invoices are left out, because Xero would post them as money owed. They are still in the standard layout, which is what to use for reconciling your own register.

The export doesn't talk to Xero directly: you upload the file to Xero yourself. There is no connection to MYOB or QuickBooks, and nothing in Horsify changes when you change something in your accounting software.

What the figures mean

  • Dates are your organisation's own calendar days, not UTC, so an evening entry stays on the day it was taken.
  • Amounts are in your organisation's currency, which the file states in a column of its own. Nothing is converted.
  • Balance owing matches the Invoices & Receipts page exactly: it is the same calculation, so a figure you query in the file can be traced back to the invoice on screen.
  • The GST rate column states the rate that invoice charged, not your market's rate today.

For your actual Stripe processing costs and payout reconciliation, your Stripe dashboard is the better source.

If something goes wrong

The export won't run because there are too many records

One export carries at most 10,000 records. Over that, narrow the dates or untick a status.

Xero says the GST is doubled

The file was imported as Tax Inclusive. Import it again as Tax Exclusive.

Related guides


Still need a hand? Open the Help bubble at the bottom of any Horsify page to ask a question or send us a message, or email support@horsify.com.au.
More guides on this topic: Payments and finance.
Tags
Sending monthly statements to your clients
Connecting your own Xero