Skip to content

The statement file

For accounting software Tuppence doesn’t connect to, download your Tuppence money as a bank statement and import it. It holds the same postings a connected tool gets: one line for each day’s sales, one for each day’s fees and refunds, and one for each payout on the day it arrived. Sage 50, KashFlow, Pandle, Zoho Books, FreshBooks and any tool that imports a bank statement take it. It needs no connection.

  1. Add an accounta bank account called Tuppence
  2. DownloadCSV or OFX
  3. Importinto that account
  4. Match payoutsto your bank feed

In the dashboard, open Settings › Accounting and choose Download for your accountant. Owners, admins, managers, developers and analysts can, so an accountant invited as an analyst can fetch it themselves. Or ask the API:

Terminal window
curl "https://api.tuppence.ai/v1/accounting/statement.csv?from=2026-10-01&to=2026-10-31" \
-H "Authorization: Bearer $TUPPENCE_SECRET_KEY" \
-o tuppence-statement-2026-10-01-2026-10-31.csv
Terminal window
curl "https://api.tuppence.ai/v1/accounting/statement.ofx?from=2026-10-01&to=2026-10-31" \
-H "Authorization: Bearer $TUPPENCE_SECRET_KEY" \
-o tuppence-statement-2026-10-01-2026-10-31.ofx
from, toBusiness dates (YYYY-MM-DD, inclusive) in your time zone. Neither: last month. One alone: the rest of that month
RangeAt most 92 days. A longer one is 400 parameter_invalid, saying which part to ask for first
KeyA secret key, or a restricted key with balance:read
AnswerThe file, as a download named tuppence-statement-<from>-<to>.csv (or .ofx)
  1. In your accounting software, create a bank account called Tuppence in your currency, once.
  2. Import the file into it with the software’s bank statement import (CSV or OFX).
  3. Code the lines: Tuppence sales to sales, Tuppence fees and refunds to fees and refunds (each line’s memo in the OFX lists what it holds). Code Payout to your bank as a transfer to your business bank account.
  4. When your bank feed brings in the payout, match it to that transfer, never as sales.

Each line has a FITID that never changes: the same days downloaded again give the same FITIDs, so importing an overlapping file adds nothing twice. The closing balance is your Tuppence balance at the end of to.

Columns Date, Description, Reference, Amount (signed, money in positive), Balance and FITID. One business day of payment-link sales, its fees and a refund, then the payout:

Date,Description,Reference,Amount,Balance,FITID
13/10/2026,Tuppence sales,Tuppence 13 Oct 2026,120.00,120.00,981e5ef82ed35deb4865c76c3e456bea
13/10/2026,Tuppence fees and refunds,Tuppence 13 Oct 2026,-5.42,114.58,deea9f808be7c2914fa1204d85b7d94c
15/10/2026,Payout to your bank,Tuppence payout po_01JA8YQ6ZK3X,-114.58,0.00,cbda40fc605814c1cc32afd70b5c413a

Dates are DD/MM/YYYY.

Date,Description,Reference,Amount,Balance,FITID
10/13/2026,Tuppence sales,Tuppence 13 Oct 2026,120.00,120.00,981e5ef82ed35deb4865c76c3e456bea
10/13/2026,Tuppence fees and refunds,Tuppence 13 Oct 2026,-5.42,114.58,deea9f808be7c2914fa1204d85b7d94c
10/15/2026,Payout to your bank,Tuppence payout po_01JA8YQ6ZK3X,-114.58,0.00,cbda40fc605814c1cc32afd70b5c413a

Dates are MM/DD/YYYY.

DescriptionWhat it is
Tuppence salesA day’s sales, tips, cashback and other money in
Tuppence fees and refundsA day’s Tuppence fees, refunds, disputes and other money out
Payout to your bankA payout, on the day it arrived
Money in from your bankA returned payout, or money paid in from your bank, such as a card top-up
Transfer from Tuppence to Tuppence cardMoney moved to your card balance (and back)

OFX 1.0.2, which desktop and online tools import. The account is TUPPENCE- and eight characters of your account id (-TEST added in test mode), bank id TUPPENCE, type CHECKING. Each line is a STMTTRN (CREDIT or DEBIT) with its FITID; NAME is the description and MEMO lists the lines it holds (Sales: payment links 115.00; Tips to pass on 5.00). LEDGERBAL is the closing balance.

Docs assistant

Open as a page
Loading the assistant…