
Clear the right confirmed transactions, monitor the difference, and finish the reconciliation only when the selected activity agrees to the statement ending balance.
When To Use This
Use this workflow after a reconciliation session is started and you are ready to clear transactions and finalize the statement.
Before You Start
- A reconciliation session is already active for the account.
- The account’s
Statement opening balance,Statement ending balance, and statement date range are already set. - The transactions you plan to clear are confirmed and belong to the selected account.
Steps
- Open
Reconcilefor the correct account. - Confirm that the summary bar shows
Beginning balance,Spent,Received,Cleared balance,Statement ending balance, andDifference. - Review the preselected transactions and adjust the selection as needed:
- Leave selected only the confirmed transactions that should clear on the statement.
- Remove transactions that fall inside the date range but should not clear yet.
- Add any eligible confirmed transactions that belong on the statement and are still unselected.
- Use filters, sorting, or grouping to review the list more efficiently.
- Watch the summary bar as you change the selection:
Cleared balanceis calculated from beginning balance, spent, and received totals.Differencemust reach zero before a normal reconciliation can finish.
- When the difference is zero, select
Finish.
- If a later reconciliation period carries an opening balance that already equals the statement ending balance, SPRK can finish the quiet period with zero selected transactions.
- If needed, use
Exportbefore finishing to download the current reconciliation table as a CSV review file. - After the reconciliation is posted, use
HistoryandView report, or useMore>Print Bank Rec, when you need to review the bank reconciliation report for that posted statement period.
What Happens Next
SPRK finalizes the reconciliation for the selected statement window.
- Finishing a reconciliation does not create a new journal entry in the general ledger.
- SPRK creates a posted reconciliation record for the account and statement ending date.
- The posted statement ending balance becomes the beginning balance source for later reconciliations on the same account.
- Each selected confirmed bank transaction is stamped as reconciled, tied to that reconciliation record, and marked with a cleared date and statement end date.
- SPRK requires the difference to be zero for reconciliations with prior history.
- Later reconciliations can finish with no selected transactions when the carried opening balance already equals the statement ending balance.
- Posted reconciliation records can be reviewed later from reconciliation history and the Reports
Reconciliationtab. - If a later supported journal correction explicitly voids a posted session, SPRK retains the session in
Historywith statusVoided; that session no longer supplies the opening balance for future reconciliations.
If Something Looks Wrong
| What You See | What To Check | What To Do Next |
|---|---|---|
| The action is unavailable or does not complete | Trying to finish while the difference is not zero | Use the supported prerequisite or correction path first |
| You are about to take an action that may affect the result | Clearing transactions from the wrong account | Confirm the visible company, page, and workflow state before continuing |
| The page does not show the expected result | Expecting pending bank transactions to be available for final clearing | Review the visible action or related workflow before continuing |
| The entered value or selection does not produce the expected result | Selecting a row just to finish a quiet statement period when the beginning and ending balances already match | Correct the value or selection before continuing |
| The result looks ready, but a key check is unresolved | Assuming reconciliation changes the original account coding of a confirmed bank transaction | Verify the visible SPRK state before continuing |