Corrections and Reconciliations

After importing the bank statement, the Checking account shows a red “Bank Balance — Discrepancy” row. This means FundOS’s running balance of cleared and reconciled transactions does not match the balance the bank reported in the OFX file. Alex’s manual opening balance is the cause — it was entered as a placeholder before the real transaction history was known, and it has not been reconciled, so FundOS excluded it from the cleared total.

The Checking account showing a red Bank Balance — Discrepancy row after the OFX import

The discrepancy row shows the amount the opening balance needs to be. Because the original opening balance was never reconciled, it has no effect on the cleared running total, which means the discrepancy amount is exactly the correct value for the new opening balance — no math required.

Making a Correction

Alex clicks the dropdown arrow on the opening balance transaction to expand it.

The opening balance transaction expanded, showing the Edit, Make Correction, and Delete Transaction buttons

Imported transactions cannot be corrected or deleted from within FundOS — those buttons only appear on manually entered transactions. This is intentional: the bank’s record is the source of truth, and changes to imported transactions are handled through future imports.

Alex clicks Make Correction. The correction dialog opens pre-filled with the original transaction’s details. Alex changes the amount to match the discrepancy row, checks Reconciled, and sets the reconciled date to May 31 — the day before the first imported transaction. The date recorded can be left at its current value.

The correction dialog pre-filled with the original opening balance details, with the amount and reconciled date updated

Alex clicks Save. The original opening balance is hidden from the register — FundOS keeps it in the database for audit purposes but it no longer appears in the account view. The correction takes its place.

After the Correction

The discrepancy row turns green and the amount column is empty, indicating that FundOS’s records now agree with the bank’s reported balance.

The Checking account showing the green Bank Balance row after the correction is reconciled

The correction transaction itself has no fund allocations — corrections never carry forward the allocations from the transaction they replace. The row is yellow. Alex re-opens it, allocates the full amount to Emergency Savings, and saves.

The Credit Card account had a similar discrepancy. Rather than making a correction — there was no prior manual transaction to replace — Alex creates a new transaction marked reconciled on May 31, using the discrepancy row the same way to determine the correct amount.

How FundOS Orders Transactions

FundOS splits transactions into two groups when calculating the running balance.

Cleared and reconciled transactions form the settled portion of the balance, calculated first. Bank-imported transactions are marked cleared automatically. The reconciled checkbox exists for manual transactions where you want to make the same claim: you have personally verified this transaction against your real-world records and the money has moved. Both carry the same weight. Settled transactions are ordered by effective date — the bank-cleared date if one was recorded, otherwise the reconciled date.

Pending transactions — manual entries that are neither bank-cleared nor reconciled — are ordered by date recorded and stacked on top of the settled total. They represent money that is expected to move but has not yet been confirmed.

This is why the reconciled date on the correction matters. Setting it to May 31 places the opening balance before the first imported transaction in the settled calculation, giving every subsequent cleared transaction a correct starting point to build on.