FreelanceTaxStrategy.comField guidesGuides
Field guides

Year-End Cash-Basis Cutoff Log: Payments Received vs Open Invoices

This guide is US federal recordkeeping education as of the source-check date, 2026-11-12. It is a bookkeeping illustration for a year-end cash cutoff. It is not a filing instruction, not a method-of-accounting election, and not a suggestion to hold a check into the next year. Every name, invoice, and dollar below is synthetic. The IRS Recordkeeping page says you may choose any recordkeeping system suited to your business that clearly shows your income and expenses, and that good records help you identify sources of income. You keep those records as long as you need them to prove the income or the deductions on a return. This log is one way to make the year-end cutoff visible. It is not a required form.

Publication 538 (revised January 2022), Accounting Periods and Methods, says that under the cash method you include in your gross income all items of income you actually or constructively received during the tax year. The same publication says income is constructively received when an amount is credited to your account or made available to you without restriction, and that you do not need to have possession of it for that rule to apply. It also says you cannot hold checks or postpone taking possession of similar property from one tax year to another to postpone paying tax on the income. You report the income in the year the property is received or made available to you without restriction. This sheet records dates you can point to. It does not decide whether the cash method is allowed in your business. Publication 538 describes exceptions, including inventory rules for merchandise, and this worksheet does not apply those tests.

The IRS page What is taxable and nontaxable income says a valid check that you received, or that was made available to you, before the end of the tax year is income constructively received in that year, even if you do not cash the check or deposit it until the next year. The same page says that if the check was mailed so that it could not possibly reach you until after the end of the tax year, and you could not otherwise get the funds before the end of the year, you include the amount in the next year. Those two sentences are why this log separates a received date from a bank-post date, and why an unknown arrival date sits in its own column instead of being guessed into December or January.

What the cutoff is separating

At year-end a freelance set of books often has two piles that look alike on a screen: money that arrived, and invoices that are still unpaid. A cash-received log puts only the first pile in the year's received total. The second pile stays in open receivables. Adding them together makes the year look as if it includes bills that have not been collected. Dropping a check that was in hand in December, only because the bank stamp is in January, makes the year look short. The residual exists so neither mistake can hide inside one unlabeled total.

The population has to be named before any dollar is classified. On this sheet the selected set is every invoice still open on the morning the year began, plus every invoice issued during the year, for one set of books. Anything outside that set is named as out of scope. An invoice you forget to list does not fail the residual, because the residual only checks the rows you included. The inclusion rule is what keeps a forgotten invoice from disappearing quietly. Write the rule in the header, then list the IDs that meet it.

This page is not a bank reconciliation. The bank reconciliation trail explains why a statement balance matches the books. This log explains which invoice dollars were received inside the year and which were still open when the year closed. Both can be true of the same deposit: the bank line cleared, and the invoice it paid is in the received column because of the date the payment was in hand or posted, not because the reconciliation "accepted" it. A customer deposit already written up on the client deposit sheet is excluded here by ID, so the same cash is not counted on two income logs. Platform fees stay on the platform payout log. When a payout is what satisfied an invoice, this sheet records the invoice face, the amount that satisfied it, and the payout reference. It does not recompute the fee.

Fields and the residual identity

Header: books label, tax year or the exact closing date if it is not December 31, currency, the inclusion rule, and a reminder that the columns are a cash-received classification rather than a tax-due figure. The example below uses a calendar year ending 2026-12-31 because that date is written on the sheet. A different closing date replaces 2026-12-31 everywhere. Do not keep December language on a fiscal-year file.

Give every invoice a stable ID and do not reuse it. Columns, in order: invoice date, counterparty label, face amount, year-end class, payment reference and received date if any, bank reference even when it falls in the next year, amount received in the year, amount still open, amount excluded with the other log's ID, amount unresolved, and a note. The class is a label, not a second amount. Partial payments use both a received amount and an open amount on the same ID. Do not split one invoice into two IDs to make the columns look simpler, unless you record a parent ID so the face is not counted twice.

The identity on each row is face = received in the year + still open + excluded + unresolved. The identity on the sheet is the sum of faces equals the sum of those four columns. Residual = sum of faces minus (received + open + excluded + unresolved). If the residual is not zero, stop. Name the row that breaks. Do not type a plug into open invoices or into received payments to force a zero. A zero residual does not prove the dates are right. It proves every face dollar was assigned to exactly one of the four columns. The dates and the payment references are what make the assignment a cutoff instead of a shuffle.

A payment with no invoice does not get forced onto an open invoice to heal the residual. Give it its own ID, mark it unapplied, and leave it out of an invoice face until you know which invoice it belongs to. Forcing it onto INV-whatever changes both the received column and that invoice's open balance without evidence. Publication 538's cash-method income rule is about amounts actually or constructively received. It is not an instruction to attach unidentified cash to the oldest open bill.

Worked example: eight synthetic invoices at a calendar year-end

The books are labeled Case K. The year is calendar 2026. Currency is US dollars. No row is a customer, a bank, or a return. The inclusion rule is the one above: carry-in open invoices plus invoices issued in 2026. Bank interest is out of scope even though Publication 538's constructive-receipt example is about interest a bank credited in December and that the taxpayer did not book until the next year. If Case K had interest credited in December, it would be its own row outside this invoice population, not a silent addition to an invoice. This example has no interest row, so the received total below is not "all cash-method income." It is the received column of this selected set.

INV-K-1790 was issued 2025-12-15 for 900.00 and was still open on the morning of 2026-01-01. An ACH posted 2026-01-08, payment reference PMT-8701, bank trace ending 2218, for 900.00. Received in 2026: 900.00. Open at year-end: 0. The invoice date is the prior year. The cash date is 2026, so the received column includes it once. It is not also recorded as a 2026 sale. The face sits in the population once, as carry-in.

INV-K-1841 was issued 2026-11-02 for 2,400.00. An ACH posted 2026-11-18, payment reference PMT-8841, bank trace ending 4412, for 2,400.00. Received: 2,400.00. Open: 0. The payment reference and the invoice ID are different strings on purpose. The invoice is what was billed. The payment reference is what you can find on the bank list.

INV-K-1855 was issued 2026-12-04 for 1,800.00. Check 1044 was in hand on 2026-12-29 and was deposited on 2027-01-03, bank trace ending 0194. Under the rule written on this sheet, a check in hand on December 29 is received in 2026. The January deposit date is a bank reference, not the cutoff. Received: 1,800.00. Open: 0. This row is not a plan to hold the check. The example assumes the check was already in hand on December 29. Publication 538 says you cannot hold checks to postpone tax. The log records the date you write down. It does not tell you to choose a later date.

INV-K-1860 was issued 2026-12-12 for 3,250.00. There is no payment reference by 2026-12-31. Received: 0. Open: 3,250.00. The December invoice date does not move 3,250.00 into the received column. An invoice is a bill. On a cash-received log, the bill is not the receipt.

INV-K-1862 was issued 2026-12-09 for 1,000.00. A card payment on 2026-12-20, reference PMT-8902, paid 400.00. The rest is unpaid. Received: 400.00. Open: 600.00. The row identity is 400 + 600 = 1000. Do not close the 600.00 because the year "should not show receivables," and do not move the unpaid 600.00 into received because a partial payment feels like the client intends to finish. Intention is not a payment reference.

INV-K-1866 was issued 2026-12-20 for 750.00. The note on the sheet says the payer mailed a check that, on the facts written here, could not arrive until 2027-01-02, and that no check was in hand on 2026-12-31. Received: 0. Open: 750.00. The taxable-income page describes that mailing pattern as next year's income. This row uses that description only because the arrival date is written as 2027-01-02. If the arrival date were blank, the 750.00 would sit in unresolved, not in open and not in received.

INV-K-1830 was issued 2026-10-01 for 500.00. The cash was recorded on the client-deposit sheet as DEP-K-44. Received on this sheet: 0. Open: 0. Excluded: 500.00, pointer DEP-K-44. The exclusion stops a double count. It is not a conclusion that 500.00 is nontaxable. The taxable-income page says prepaid income, such as compensation for future services, is generally included in the year you receive it, and it separately describes an accrual-method deferral this sheet does not apply. The deposit log remains the place where that cash is followed until it is applied. This cutoff log only shows that the 500.00 is not also sitting in the received column here.

INV-K-1868 was issued 2026-12-28 for 200.00. The counterparty says a check was mailed on 2026-12-30. Nothing is in hand, nothing has posted, and no arrival date is written. Received: 0. Open: 0. Unresolved: 200.00. Leaving it unresolved keeps the face on the sheet. Putting 200.00 in received would claim a payment the file does not have. Dropping the row would hide the face. The residual is what makes the drop visible, but only if the row was listed under the inclusion rule in the first place.

The additions, without the thousands separators, are the check you can retype. Faces: 900 + 2400 = 3300, 3300 + 1800 = 5100, 5100 + 3250 = 8350, 8350 + 1000 = 9350, 9350 + 750 = 10100, 10100 + 500 = 10600, and 10600 + 200 = 10800. Received: 900 + 2400 = 3300, 3300 + 1800 = 5100, and 5100 + 400 = 5500. Open: 3250 + 600 = 3850 and 3850 + 750 = 4600. Then 5500 + 4600 = 10100, 10100 + 500 = 10600, and 10600 + 200 = 10800. Residual is 10800 − 10800 = 0. The year-end received total for this selected set is 5,500.00. Open receivables at year-end are 4,600.00. Those two numbers stay in different columns.

Adding them is the mistake the sheet is built to catch. 5500 + 4600 = 10100 is a real sum, and it is the wrong income figure for this log, because 4,600.00 has no payment reference inside 2026. The residual still has a home for that 4,600.00. The home is the open column, not the received column. Someone who "recognizes December billings" by pouring open invoices into received has not found new cash. They have emptied the open column and broken the distinction the cutoff exists to keep.

Moving the December 29 check into the next year, only because the deposit stamp says January 3, also keeps a zero residual and still mis-classifies the row under this sheet's rule. Received would fall by 1,800.00: 5500 − 1800 = 3700. Open would rise by the same amount: 4600 + 1800 = 6400. The faces would still add up. A zero residual did not protect the date. The payment reference did: check 1044, in hand 2026-12-29, deposit 2027-01-03. If that in-hand date is wrong, correct the date and move the 1,800.00. Do not move it because a later bank stamp feels cleaner.

How the other logs stay attached

Tie the received column to the bank trail by payment reference and amount, not by retyping the 5,500.00 from memory. PMT-8841 for 2,400.00 should be findable as one bank line or one payout line. If the bank line is 2,310.00 because a platform took a fee, do not change the invoice face on this sheet to 2,310.00 and do not call the difference an open balance. The fee belongs on the platform payout log, where gross billed, fee, and net deposit are already a three-part identity. This cutoff then either records the gross amount that satisfied the invoice, with the payout ID as the reference, or it records a partial application if that is what the invoice shows. It does not invent a second fee math.

DEP-K-44 is the same kind of pointer. The 500.00 is in the face sum so the invoice is not dropped, and it is in the excluded column so it is not received again. When the deposit is later applied to a final invoice, the deposit sheet is where the application and any remainder are written. If that final invoice is also in this year's population, the exclusion note should name both IDs before you close the row. Closing INV-K-1830 into received, while DEP-K-44 still carries the cash, is the double count the column was added to prevent.

Information returns are a third file. A Form 1099-NEC or Form 1099-K can report an amount that does not match this received column. The 1099 matching worksheet is where a form box is tied to the books. This cutoff does not "fix" a form by moving INV-K-1860's 3,250.00 into received so the column looks closer to a form. If a form includes the January deposit of check 1044, the match worksheet is where you show that the check was already in the prior year's received column under the rule you wrote down. This page does not compute the tax on either figure.

A one-page template to copy

Header line: books label, period start, period end, currency, inclusion rule, and the sentence "received means in hand, posted, or otherwise written as received on a date inside the period; a later bank stamp is a reference." Columns: stable invoice ID, invoice date, counterparty, face, class, payment reference, received date, bank reference, received amount, open amount, excluded amount plus foreign ID, unresolved amount, note. Close line: face sum, received sum, open sum, excluded sum, unresolved sum, and residual = faces − (received + open + excluded + unresolved). If the residual is not zero, write the break in words under the close line and stop. Do not drop an unresolved row to manufacture a zero, and do not slide an open balance into received because the residual is already zero and the open column feels untidy.

A partial payment stays on one ID. INV-K-1862 is the pattern: 400.00 received, 600.00 open, face 1,000.00, reference PMT-8902 on the received piece only. The open piece has no payment reference. Writing "client will pay in January" in the note does not create a January row in this year's received column, and it does not remove the 600.00 from open. Next year's log picks up that open balance as carry-in, the way INV-K-1790 arrived from 2025, and records the later payment on the later received date.

Common mistakes

Treating the invoice date as the cash date. INV-K-1860 is dated in December and is still open for 3,250.00. Billing is not receipt. Publication 538's cash-method sentence is about income you actually or constructively received during the year, not about invoices you issued during the year.

Using the bank-post date as the only date. Check 1044 was in hand on 2026-12-29 and deposited on 2027-01-03. Under this sheet's rule the 1,800.00 stays in 2026. The taxable-income page says a valid check received before year-end is income in that year even if it is deposited in the next year. The January stamp is a reference on the row, not a reason to delete the December date.

Holding a check so the received date moves. The log is not a method for that. Publication 538 says you cannot hold checks from one tax year to the next to postpone tax. If a check is in hand, write the date it was in hand. If it is not in hand, do not invent an in-hand date to put the dollar in the year you prefer.

Clearing unresolved into received or into open to finish the file. INV-K-1868 stays at 200.00 unresolved until a received date or a written decision that it is still simply unpaid. Guessing "it probably arrived" is not a payment reference. Guessing "leave it open" without saying the check never came is a different fact. Write the fact you have.

Counting a deposit twice. INV-K-1830's 500.00 is excluded here because DEP-K-44 already has it. Putting it in received as well makes the cash exist twice. The residual will still be zero if you also remove it from excluded. Zero is not a defense against a wrong column.

Adding open receivables to received payments and calling the sum income. 5,500.00 + 4,600.00 = 10,100.00 on this file. That sum mixes unpaid invoices into the cash cutoff. The open column is supposed to survive the year-end close.

Plugging a difference. If the face sum will not reconcile, the missing piece is a row, a reference, or a bad amount. A plug labeled "cutoff adjustment" with no ID hides the break the residual was meant to show.

Assumptions and limits

All names and amounts are hypothetical. The sheet does not decide whether you are allowed to use the cash method, does not apply an inventory exception, and does not compute a gross-receipts test. Publication 538 is where those limits are described. This page does not restate a dollar threshold, because a threshold that is indexed over time is easy to copy wrong, and this log does not need it. The log also does not decide constructive receipt in a case the file does not document. Unresolved is the honest column when a mailed check has no arrival date. It is not a finding that the income is untaxed, and it is not a write-off.

Property and services are outside the numeric example. Publication 538 says that if you received property and services, you include their fair market value in income under the cash method. The taxable-income page also discusses barter. This sheet has no barter row and does not invent a value. If a job was paid in goods, give it an ID, point at the document that states a value, and do not drop the face into the cash columns as if a check had arrived. Owner draws, personal card splits, and mileage are different logs. They do not belong in the received-invoice total just because they moved through the same bank account.

Nothing here is a Schedule C line, a self-employment tax figure, or a 1099 instruction. Nothing here tells you to delay a deposit, to date a check for a later year, or to leave a payment undeposited. The 5,500.00 is the received column of eight synthetic rows under rules written on the page. It is not Case K's taxable income, because the example excluded interest on purpose, excluded a deposit only by cross-reference, and left 200.00 unresolved. Change one date or one column and the 5,500.00 changes. That is the worksheet working, not a rate and not a result you can copy onto a return.

Sources and method

AI-assisted writing with automated source, calculation and editorial checks. No hands-on testing or professional certification is claimed. Check the stated assumptions before applying this guide.