Use posted bank transactions and the banking register
Pixie CRM guidance. Follow the route for your workspace, check your role and enabled modules, and verify the result before moving on.
Follow this guide to review bank transactions already represented in Accounting and compare them with the bank-account ledger balance.
What you’ll accomplish
Review bank transactions already represented in Accounting and compare them with the bank-account ledger balance. It forms part of Pixie CRM Enterprise CRM's Accounting & Bookkeeping module and uses the module's permission-aware controller, status and mapping flow rather than a generic spreadsheet process.
How it works
The module provides separate posted-bank-transaction and banking-register tables. Posted status concerns the Accounting workflow; reconciliation concerns agreement with the external statement.
A posted transaction can remain unreconciled because of timing or an incorrect match. A reconciled item should have supporting bank evidence.
Use Bank Reconciliation Detail for the completed reconciliation record.
Follow these steps
- Select the bank account.
- Go to Posted Bank Transactions and filter the period.
- Check source references and unusual entries.
- Go to the Banking Register for running balance context.
- Compare the register with the statement and feed.
- Resolve missing, duplicate or unmatched items.
- Proceed to reconciliation.
Settings to check
Check it worked
After the action is saved, Pixie CRM keeps the Accounting record connected to its source and updates the visible status or ledger data supported by this workflow. Review the saved result rather than relying only on a success message. Where the action posts accounting data, total debits and credits must balance and the accounts must match the approved mapping or manual selection.
- Open the saved record and confirm its final status.
- Review the source reference and every debit and credit line where ledger data was created.
- Use the relevant register, ageing, reconciliation or report to verify the wider effect.
Common mistakes to avoid
- Do not assume Posted means reconciled.
- Use the correct opening date.
- Investigate manual adjustments.
- Protect exported bank-register data.
- Use the least destructive correction available and record the reason for material changes.
- Do not bypass a permission, approval or closed-period control by changing unrelated data.