Who owes you, what you owe, and where the business stands today

Business reports in 2Fin are the views a sole trader or small company runs the books by between tax returns: aged receivables and aged payables by how late each amount is, a balance sheet as at today, and loan repayment and prepaid expense schedules. They are on ELITE+ and AUTO+, and on AUTO+ a report can arrive by email on a schedule, as a PDF or CSV file.

Every amount owed, in the age band an accountant reads.
What the business owns and owes, and how each loan runs down.

How the reports come together

  1. Step 1

    Keep the books for a business

    The reports read books kept for a business on ELITE+ or AUTO+: a sole trader’s or a small company’s.

  2. Step 2

    Bring in the bank, and what you are owed and owe

    A bank feed or statement uploads for the accounts; invoices you send from 2Fin or record as expected income; the bills Fin found repeating or you added.

  3. Step 3

    Open the aged lists

    Aged receivables and aged payables, by customer or payee, as at today — download as CSV or print.

  4. Step 4

    Read the balance sheet as at today

    What the business owns and owes from what 2Fin can see, with any account that has no reported balance listed as not known.

  5. Step 5

    Have them arrive on their own

    On AUTO+, schedule a report to your account address daily, weekly, monthly or quarterly, as a PDF or CSV attachment or in the email.

Aged receivables: who owes you, and for how long

An aged receivables report lists the money customers owe you, grouped by how far past its due date each amount is. In 2Fin the amounts come from what you are owed — expected income, including every invoice you send from 2Fin — so the report agrees with Upcoming and your profit and loss. Each customer gets a row across five columns, each currency gets a block of its own and is never added to another, and the report downloads as CSV or prints. Aged receivables: who owes you, and for how long.

ColumnWhat is in it
Not yet dueDue today or later. An amount due today is on time.
1–30 days1 to 30 calendar days past the due date.
31–60 days31 to 60 days past due.
61–90 days61 to 90 days past due.
Over 90 days91 days or more past due — usually the first conversation to have.

Aged payables: what you owe, and what is late

The same five columns for the bills you owe: each payee’s unpaid bills by how late they are, per currency, as CSV or print. Bills come from your bill patterns and the bills you added, and the list holds the ones overdue or due within the next 30 days, so a monthly rent counts as owed when it falls due rather than two years of it at once. Paying the late ones first keeps suppliers on your side. Aged payables, defined.

A balance sheet as at today, from what 2Fin can see

A balance sheet sets what a business owns against what it owes on one day. 2Fin’s is read-only and as at today, built from figures it already shows elsewhere, so it cannot disagree with them. An account with no reported balance is listed as not known and left out of the totals rather than guessed. It is a statement of what 2Fin can see, not audited accounts: the year-end accounts stay with your accountant, who gets the figures in the accountant pack. What a balance sheet is, for a sole trader or small company.

What the business owns

  • Cash and investment accounts

    At the balance the bank reports for each account, the same reading the cash flow forecast starts from.

  • Money owed to you

    What customers still owe, the same items as the aged receivables.

  • Equipment

    At its written-down value from the asset register, for the current financial year.

What the business owes

  • Card and loan balances

    As the bank reports them, so the figure is the bank’s own.

  • Bills owed

    The same bills as the aged payables: overdue, or due within the next 30 days.

  • GST or VAT owing

    From your tax set-aside, the amount put aside for the next activity statement or return.

Equipment comes from the asset register, and the bank balances read best once each account has passed a balance check.

Loan and prepaid expense schedules, worked out on the page

Loan repayment schedule

Enter the amount borrowed, the annual rate, the term and how often it is repaid — weekly, fortnightly or monthly — and the schedule lists every repayment split into interest and principal, with the balance left after each. The last repayment absorbs the rounding, so the loan ends at zero to the cent.

Prepaid expense schedule

For a cost paid up front, such as a year of insurance, enter the amount and the months it covers and Fin spreads it evenly month by month, on the same month boundaries a spreadsheet’s EDATE gives, so your accountant’s workings agree. Any leftover cents go in the last month.

Both are worked out as you type and are not stored. To try the loan side without an account, use the free loan repayment calculator. Definitions: loan amortisation, prepaid expense.

Reports on a schedule, as a PDF or CSV

On AUTO+, choose a report and how often it should arrive — daily, weekly, monthly or quarterly — and it is emailed to your account address. The email can carry the report as a PDF or CSV file, ready to file or forward, or keep it in the body of the email. Profit and loss joins the activity-statement figures (BAS in Australia; the VAT or GST return elsewhere), the depreciation report, the tax export summary and the Insight+ summary. Scheduling is part of the web app.

Who it is for

The reports are for books kept for a business, from a sole trader to a small company, and for the accountant who reads them.

Around the reports

Definitions: aged receivables, aged payables, balance sheet.

Business reports, answered

Questions about the business reports

What does an aged receivables report show?
A list of the money customers owe you, grouped by how far past its due date each amount is: not yet due, 1–30 days, 31–60, 61–90 and over 90 days. It shows at a glance whom to chase first and how much of what you are owed is getting old. In 2Fin it is built from what you are owed, including the invoices you send from 2Fin, with a block for each currency.
How does 2Fin decide which column an unpaid invoice goes in?
By calendar days past its due date on the day you run the report. An amount due today or later is not yet due; one to 30 days past is in 1–30, and so on to over 90. An item that has been paid or written off drops off the list, and a part-paid one shows what is still owed.
Can 2Fin produce a balance sheet for my business?
Yes, a read-only balance sheet as at today, on ELITE+ and AUTO+: cash and investment accounts at the balance your bank reports, money owed to you and equipment at its written-down value from the asset register, against card and loan balances, bills owed and the GST or VAT owing from your tax set-aside. It is a statement of what 2Fin can see, not audited accounts; your accountant prepares the year-end accounts.
Why is an account shown as not known on my balance sheet?
Because no balance has been reported for it, and 2Fin does not guess one. The account is listed so you can see it is there, and left out of the totals so they stay true to what is known. Once a balance is reported for it, the account joins the totals.
How do I work out how much of a loan repayment is interest?
Each repayment’s interest is the balance still owing times the rate for that period, and the rest of the repayment comes off the balance. That is why early repayments are mostly interest and later ones mostly principal. The loan schedule in 2Fin’s reports works this out for every repayment, and the free loan repayment calculator on this site does the same without an account.
Can 2Fin email my reports as a PDF?
Yes, on AUTO+. A scheduled report can arrive attached to the email as a PDF or CSV file, or in the body of the email, daily, weekly, monthly or quarterly, at your account address. Profit and loss, activity-statement figures, the depreciation report, the tax export summary and the Insight+ summary can each be scheduled.
Which plan includes the business reports?
ELITE+ and AUTO+, alongside the activity statement, the asset register and profit and loss, for books kept for a business. Reports emailed on a schedule are on AUTO+, in the web app.

Know who owes you before you start chasing.

Start free with your bank file and statements, and move to ELITE+ or AUTO+ when the business needs the reports.

Terms used on this page

Full glossary →