Freelancer bank deposits: separate client receipts, personal funds and loans before totaling

Publication 583 distinguishes deposit sources

IRS Publication 583, revised December 2024, makes the distinction directly. Its “Business checkbook” section recommends leaving room to identify deposit sources as business income, personal funds or loans, and noting the source on deposit slips. Its “Identify source of receipts” section explains why: records help separate business from nonbusiness receipts and taxable from nontaxable income. Those are distinctions to establish with evidence, not labels a bank description can settle for you.

For the starting records, use the bank's native transaction export if it covers your dates, plus the original statements. Keep the scope to one account, one currency and an explicit period. You're reviewing posted credits, but leave the debit side of your original file intact: a later reversal or returned payment may explain why a deposit needs more investigation. Missing statement periods and overlapping exports need to stay visible so a partial list doesn't pass for a complete year.

If personal and business activity already share an account, preserve the history and label what you can substantiate. Publication 583 recommends keeping business and personal checking accounts separate. That recommendation does not magically sort the mixed records you already have.

Keep the bank fact separate from your explanation

The bank credit is a recorded amount. “Payment for my design work” is your explanation of it. Those belong in different columns so a guess made in January doesn't look like a checked fact when somebody opens the spreadsheet in April. Add the document reference and the source classification reached after review alongside them.

The supporting records need to connect your explanation to the bank row. For a client receipt, keep the invoice together with the payment or remittance record that connects it to the deposit. Compare a claimed transfer's sending-account record with the receiving entry; for claimed loan proceeds, keep the agreement and disbursement record. These are review prompts, not a promise that a particular set of documents establishes legal or tax treatment. A matching amount alone isn't enough to choose between two possible sources.

The IRS page “What kind of records should I keep”, last reviewed or updated August 3, 2026, says supporting documents should show the amounts and sources of gross receipts. It lists deposit information, receipt books and invoices among the examples. Save those records alongside the worksheet, rather than replacing them with a typed explanation.

Four fictional credits total $3,960, not a finished income figure

This synthetic example covers four posted credits in one fictional USD checking account during September 2025. It is a selected deposit list, not a full bank statement. Assume the fictional supporting records establish the sources of the first three credits; the fourth remains unexplained. No real client, loan or tax return is represented.

Import this comma-delimited CSV into A1:G5 of a blank worksheet, with columns C and G as numeric values, and check that the preview shows seven columns. The example IDs stand in for your source references. In a real worksheet, each ID needs the source filename and page or row, along with the original bank description, so you can trace it back. Put the account, currency and September date range in the worksheet heading rather than relying on somebody's memory.

RowID,PostedDate,BankCredit,ClaimedSource,EvidenceRef,ReviewedClass,UnresolvedAmount
D01,2025-09-03,2400.00,Client A project payment,E01,Client receipt,0.00
D02,2025-09-08,500.00,Transfer from personal savings,E02,Personal funds,0.00
D03,2025-09-12,1000.00,Loan disbursement,E03,Loan proceeds,0.00
D04,2025-09-19,60.00,Unknown,None,Unresolved,60.00

Put labels in H2:H7 for total credits, client receipts, personal funds, loan proceeds, unresolved amount and allocation difference. Enter these formulas beside them in I2:I7:

I2: =C2+C3+C4+C5
I3: =C2
I4: =C3
I5: =C4
I6: =G2+G3+G4+G5
I7: =I2-I3-I4-I5-I6

The results are 3,960.00; 2,400.00; 500.00; 1,000.00; 60.00; 0.00. These formulas reference the fixed example rows; they don't classify transactions or expand when you add rows. A larger worksheet needs separate totals for each reviewed source group and the unresolved amount, with their sum compared against the original bank-credit total. The grouped rows still need review alongside the arithmetic.

The zero allocation difference means every dollar in this four-row list has a place, including the $60 still awaiting evidence. It does not mean every source is known or every receipt is in the list. Report “$2,400 documented client receipts in this account and period, with $60 unresolved,” not “$2,400 taxable income.” The $500 and $1,000 remain visible in their own source groups rather than being erased from the bank data.

An unexplained credit needs a question, not a convenient label

In the example, D04 is still unexplained, so the next step is to retrieve the bank's payment detail and compare it with the receipt records. “Probably a reimbursement” would belong in the claimed-source column, not the reviewed classification. Record who checked it, when, and which document changed the conclusion so another person can follow the decision.

When you can explain only part of a deposit, record the supported portion and the remainder separately, linking both to the same bank row rather than copying the whole deposit into two source groups. A blank evidence field is still an open question, so it shouldn't automatically produce a zero unresolved amount. The explicit zeros in the example mean that its fictional review identified the entire source of those three rows, not that their tax treatment has been approved.

The IRS Recordkeeping page, last reviewed or updated August 19, 2026, says a paid preparer may need to help reconstruct missing records in the context of EITC due diligence. It describes using available documentation to develop a sound and reasonable estimate of business income and expenses to support Schedule C. That is guidance for the preparer, not a reconstruction method this worksheet performs. Bring the partial records and unresolved questions to your preparer rather than filling the gaps merely to make the worksheet look finished.

Even the client-receipt subtotal can miss part of the story

A deposit worksheet only sees money that reached the account you selected. If you also received cash that was never deposited, or client payments into another account, gather those receipt records separately. Publication 583 includes a daily cash-receipts summary in its recordkeeping example. The absence of a bank row does not establish that no receipt occurred, and a receipt later deposited should not be counted a second time merely because it appears in both records.

A net payout also needs its own explanation. In a separate fictional illustration, a settlement report showing $2,500 in customer payments less $100 in charges would explain a $2,400 bank deposit. The subtraction is simple; the bank line alone cannot tell you that the two underlying amounts were $2,500 and $100. Keep the settlement report rather than guessing fees from the difference, and let your preparer decide how each component is treated. This is not an asserted fee rate or a claim about a particular platform.

If your work comes through Uber, use the separate guide to comparing Uber tax summaries with bank deposits. Where invoice dates, payout dates and bank posting dates differ, keep each as a separate fact. Moving a bank row to make a calendar-year total agree with another report hides the timing question instead of answering it.

Use tools to organize the review, not make the decision

Once you've decided which credits belong in your selected set, the deposits-by-payer worksheet can group them by payer and month. Retain your reasons for exclusions, and keep unresolved credits in the handoff. Its payer labels are your labels, not verified identities, and its selected-deposit total is not a tax conclusion.

For sorting by date, the tax-year bucketer organizes records by the date column and calendar you choose. It doesn't decide when a receipt should be recognized for tax purposes. If you want to look at larger credits first, the large-deposit review worksheet can flag deposits above your own threshold and hold evidence notes. Choose its custom threshold mode for this sorting task, not its lender illustration: your threshold orders the work. It isn't a tax rule or a reason to ignore smaller unknown credits.

Your preparer needs to see what the totals cover, so send the original statements, this source worksheet, the referenced supporting records and the unresolved questions. State which accounts and periods are included, listing missing records and receipts outside those accounts separately. A zero allocation difference doesn't make the package complete; ask whether they need additional documents. The bank statements and tax records guide covers the broader evidence packet.

If only PDF statements remain, first check for a native bank CSV or enter a short list manually. For a longer PDF archive, AnyStatement can extract transaction rows into a reviewable spreadsheet. Conversion is a separate upload, not part of the browser-local worksheets. It supplies the bank side of this work; it cannot supply a missing invoice or decide what a deposit means.

What we checked

We reopened Publication 583 (December 2024 revision), What kind of records should I keep (August 3, 2026 footer) and Recordkeeping (August 19, 2026 footer) on October 18, 2026. We recomputed the fictional amounts and the worksheet formulas' equivalent arithmetic using Python Decimal. We did not run Excel, review a real freelancer's records or test acceptance by the IRS, a preparer or a lender. The worksheet is our document-organizing example, not an IRS form or tax advice.