Cash Basis or Modified Accrual: What Each Asks of Reconciliation

Two jurisdictions can collect the identical tax, on the identical schedule, from the identical mix of businesses, and still close their books in two entirely different ways. One records revenue when the money lands. The other recognizes it in the period it was earned, provided the money arrives soon enough to count toward that period.

Neither is wrong. Both are reconciling the same underlying transactions. What separates them is the accounting basis their financial statements are built on, and that difference determines what the journal entry has to look like when the month closes.

For finance teams, this is where tax collection software either earns its place or creates a second job.

The Same Data, Two Sets of Books

Under a cash basis, the reconciliation question is direct. What was received, into which fund, for which tax type, and during which period. Revenue and the cash move together, and the entry follows the deposit.

Under modified accrual, the question gets longer. Derived tax revenues such as sales and use, occupancy, and business license are recognized when the underlying transaction occurs and the revenue becomes both measurable and available. Availability is a policy decision, commonly set between 30 and 90 days after fiscal year-end, but determined by each jurisdiction’s revenue recognition policy. A November sale remitted in January belongs to one period for the taxpayer and potentially another for the general ledger.

That timing difference is an accounting requirement, and the software has no say in it. What the software does determine is whether meeting the requirement takes an afternoon or a week. When transaction data can only be exported one way, every period-end starts with a manual rebuild in a spreadsheet.

The more useful way to think about reconciliation is as a translation layer, turning taxpayer transaction activity into accounting-ready entries on whichever basis the jurisdiction reports.

Following One Dollar to the General Ledger

The path is worth tracing, because the handoffs are where most reconciliation problems start.

A business files a return through the taxpayer portal and submits payment. The filing carries a period date, a completed date, and revenue SKUs. The payment carries the cash amount, a method, and a completed date. Those two things are related, but they are not the same event, and they do not always arrive together. Depending on system configuration, at the time of posting, the system records the cash according to one principle, cash or modified accrual.

Reconciliation is where the cash is matched to a bank statement. Filing/payment, cash to deposit, deposit to bank statement. What comes out the other side is a set of entries that can be exported to the general ledger without re-keying. This set of journal entries either comes out under the accrual principle or the cash principle, depending on the site configuration.

Done properly, the accounting basis is something the system handles. When transaction detail is retained at the filing-period level rather than collapsed into deposit totals, both views draw on the same source.

Where It Usually Breaks

Across jurisdictions, the same handful of failure points recur.

• Incomplete filings paired with completed payments. A submission that fails partway through while the payment clears leaves money with no return behind it.
  • This is caught and corrected during the admin reconciliation process.
• Manual re-keying between systems. Every hop from collection system to spreadsheet to ERP is an opportunity for a transposition that nobody finds until the variance appears.
• Undocumented adjustments. A correction made directly in the ledger, without a corresponding record in the collection system, guarantees the two will never agree again.
• Inconsistent cadence. The most common one, and the most avoidable.

Consistency Costs Less Than Intensity

Reconciliation cadence varies widely, from daily in some offices to monthly in most, and in some cases not at all after go-live. The cadence matters less than whether it holds.

The arithmetic is straightforward. A month’s variances are reviewed against a month of memory, a month of staff notes, and a month of bank activity. A year’s variances are reviewed against none of those. The work does not scale linearly; it compounds. Offices that reconcile monthly are not spending more time on reconciliation than offices that reconcile annually. They are spending considerably less.

At Okaloosa County, FL, reporting time dropped from half a day to under 10 minutes. That kind of reduction is what makes a monthly cadence sustainable rather than aspirational.

What It Buys at Audit

The payoff for all of this arrives in a specific month each year.

Audit preparation becomes a file retrieval rather than a reconstruction when three things are already true. Entries tie to source transactions. Adjustments are documented where they were made. The basis documentation is reproducible from the system rather than from someone’s spreadsheet.

Reproducibility is the condition auditors press on hardest. An auditor asking about November revenue wants validation and supporting documentation, not just an amount. A reconciliation and the supporting detailed reports behind it, reproducible on demand, are a control. A spreadsheet that lives on a single workstation is not.

There is a secondary benefit that finance directors tend to notice before anyone else. Reconciliation surfaces problems that have nothing to do with accounting. Variances point to integration gaps, filer confusion, and training needs months before they would otherwise appear in a financial statement.

What to Ask of the System

A tax collection system serving a finance team should be able to answer two questions without a manual workaround.

1. What are my journal entries for revenue booked this period?
2. What is my supporting documentation for those entries?

Jurisdictions reporting on a cash basis or on modified accrual need answers to come from the same source data, so that the entry posted to the general ledger can be traced back to the return that produced it.

The two jurisdictions from the top of this piece will still close their books differently, and neither of them needs to change that. What matters is whether each can show where every number came from, on the basis it reports on, without rebuilding the answer by hand each period.

Want to learn more? Talk to a Neumo expert.