Using your accounting software
Take your invoices and payments into the accounting software you already use, and let your own Stripe account feed your card payments into your books
Exporting for your accounts
The Accounts export card on Export practice data prepares a download of your invoices and payments for a date range, laid out for import into your accounting software. It is included on every professional plan.
- Choose a date rangePick the first and last day to include. The card tells you the longest range a single export can cover; for a longer period, prepare one export per part.
- Choose your accounting softwareThe card then shows the files you will receive and the import notes for that software, including any column you may want to change before importing.
- Decide whether to include invoice PDFsThe PDFs are useful as attachments in your ledger or for your records. Leave them out for a smaller download.
- Prepare the exportThe card shows its progress and tells you when the export is ready to download.
- Download itFor your security you confirm your identity before the download starts. The file stays available for a limited time, shown beside it.
Exporting for your firm
What the download contains
- Invoices you have issued in the range, line by line, with the tax treatment of each line
- Credit notes for refunds and write-offs, each referring to the invoice it reduces
- Payments received, with the card processor’s fee where it is known
- Disbursements you recharged to clients
- A generic CSV with every field, whichever software you chose, so nothing is lost if your software’s import cannot carry part of it
- Invoice PDFs, if you asked for them
Your invoice numbers are kept in every file, so an imported invoice can be matched to the one your client received. Account codes are usually left for your software’s default; where a file needs one, the card’s import notes say which value it uses so you can change it.
Importing into your software
Each program has its own import screen. The steps are broadly the same: open the import option for the record type, upload the file, check how the columns are matched, then review what was imported before you approve it. The links below go to each vendor’s own instructions.
Xero
Import the sales invoices file and the credit notes file. They arrive as drafts for you to review. Xero: import customer invoices (opens in a new tab)
QuickBooks Online
Import the invoices file. QuickBooks’ invoice import does not take credit notes or payments, so those are in the generic CSV. QuickBooks: import multiple invoices (opens in a new tab)
Zoho Books
Import the invoices first, then the credit notes, then the customer payments, so each payment can find its invoice. Zoho Books: invoices, including import (opens in a new tab) and Zoho Books: payments received (opens in a new tab)
Sage Accounting
Import the sales quick entries file. Your customers need to exist in Sage first, with the same reference. Sage: import overview (opens in a new tab)
FreeAgent
FreeAgent’s invoice import is used by accountants and bookkeepers who work with FreeAgent, so pass the invoices file to yours. The card links to FreeAgent’s own instructions once you choose it.
Other software
Choose Generic CSV. It has every field in plain columns and can be mapped into most accounting and practice-management software.
Try a short date range first
Connecting your own Stripe account
Card payments from your clients are taken through your own Stripe account, which you set up when you enabled payments. It is your account, so you can connect it to your accounting software yourself. Many programs then record each card payment, each Stripe fee and each payout to your bank without an import from us.
- Xero: Stripe in the Xero App Store (opens in a new tab)
- Zoho Books: Zoho Books Stripe integration (opens in a new tab)
- FreeAgent: FreeAgent Stripe integration (opens in a new tab)
- QuickBooks Online and Sage Accounting: search for Stripe in the apps section inside your software
Stripe’s own payout reconciliation report (opens in a new tab) lists which payments and fees make up each payout, which helps when matching payouts to your bank statement.
Record each payment once
What the export does not do
- It does not sync automatically. Each export is a one-off file for the range you chose; prepare a new one for the next period.
- It does not read from or write to your accounting software. We never connect to your ledger to post anything.
- Payments you record only in your accounting software are not sent back to Orchard72. Record a payment here as well if you want the invoice to show as paid here.
- It does not choose your account codes or tax codes. Map them in your software, or ask your accountant.
- It is not accounting or tax advice. How you record each item is for you and your accountant.
Frequently asked questions
Does the export cost anything?
No. It is included on every professional plan.
Is my data shared with my accounting software provider?
Not by us. You download the file and choose where to import it; we do not send it anywhere.
Why does my software not import credit notes or payments?
Some programs’ import screens only accept invoices. The card’s import notes say which records your chosen software cannot import, and those records are always in the generic CSV so you can enter or map them another way.
Is the Stripe fee in the export?
Yes, beside each card payment, where Stripe has reported it. If your software is connected to Stripe directly, the fee is usually recorded there too.
Can’t find what you’re looking for?
Our support team is here to help. Contact us and we’ll get back to you as soon as possible.
Contact Support
