English digital workbook · US$5 · Secure PayPal checkout
CashbookFOR SMALL BUSINESS

For freelancers receiving PayPal payments

Small business.
Clear numbers.

Record gross income, estimate PayPal fees, and see what remains after expenses. One straightforward spreadsheet you keep on your own computer.

Buy with PayPal · US$5 Preview the worksheet
English XLSX file300 transaction rowsNo macros
A look insideIllustrative example · USD
Your cash, at a glanceRecorded income and expenses
Income$150.00
Expenses$40.00
Cash surplus after fees$107.00
TransactionCash effect
Cash sale+$50.00
PayPal sale, after fees+$97.00
Business expense−$40.00
A clearer view, every time you review.

Example figures only. These are not actual sales or an income forecast.

300rows for your transactions
5connected worksheets
12months in your annual view
Set up. Record.
See the bigger picture.

A purpose for every sheet

From each transaction
to the bigger picture.

Yellow cells for your entries. Blue cells for calculations. Clear instructions and a worked example help you get started.

  1. 01

    Start Here

    A quick guide to entries, payment fees, and what cash surplus means.

    The guide
  2. 02

    Settings

    Choose your currency, opening balance, report year, and estimated payment fees.

    Your setup
  3. 03

    Transactions

    Record dates, income or expenses, descriptions, categories, and payment methods.

    300 rows
  4. 04

    Overview

    See your totals and a month-by-month summary for your selected year.

    The big picture
  5. 05

    Example

    Separate sample transactions show how the calculations work.

    Learn by doing
See the actual Example sheet · one-page PDF →Free guide: record PayPal sales and fees →

Try a simple example

What’s left after
your expenses?

Change the numbers to see your cash surplus. In the workbook, this is calculated from the transactions you record, including your estimated PayPal fees.

Choose a currency label for this example. This does not convert exchange rates. Cash surplus is not the same as full accounting profit.

USD
USD
USD
Cash surplus$107.00
Income − expenses − estimated fees

One file. Your own records.

Your cashbook.
On your computer.

An English XLSX workbook designed for Excel and LibreOffice. Start with USD, EUR, or GBP, and keep your transactions in a single currency. No macros or connections to your financial accounts.

  • Income and expense records with monthly summaries
  • Editable percentage and fixed-fee estimates
  • Clear YYYY-MM-DD dates for international use
  • USD, EUR, GBP, CAD, and AUD currency labels
Small Business Cashbook
US$5One-time price
No physical item

English digital workbook · XLSX format

Buy with PayPal

After completed payment, return from PayPal to receive your protected download.

Digital file · No shippingDownload after verified payment. Save the file within the 15-minute download session.

A few useful details

Before you start.

Do I need spreadsheet experience?

The Start Here sheet explains the steps, and a separate Example sheet shows the calculations. You’ll need an application that opens XLSX files and to enter your records in the yellow cells.

Can I use euros or pounds?

Yes. Choose USD, EUR, GBP, CAD, or AUD in Settings. Use one currency for each copy of the workbook. The selection labels your amounts; it does not convert exchange rates. The purchase price is US$5.

Are the estimated fees my actual PayPal fees?

Fee settings start at zero. Enter the percentage and fixed fee that apply to your account. Estimates apply only to income marked PayPal. Record income before fees and reconcile the estimates with your payment-provider statement.

Does this calculate accounting profit or taxes?

It shows recorded income minus recorded expenses and estimated payment fees. It does not calculate tax returns, sales tax, VAT, inventory valuation, or accruals. Use it to organise simple cash movements.

Does it connect to my bank account?

No. You enter your own transactions. The opening balance starts at zero and can be changed to your own figure. The workbook does not verify bank or PayPal balances.