Review an account register and reconcile activity
Trace report categories to transactions, inspect recorded account entries and review reconciliation separately.
On this page
Identify the report, dates, property and source you are checking. For bank reconciliation, also have the correct account’s statement, opening balance and ending balance.
Account register, Account activity and bank reconciliation answer different questions. A downloaded report does not reconcile an account or establish its live bank balance.
Step 1: Open and scope Account register
In Accounting, open Reports and find Account register under Accounting utilities and exports. Open More filters, choose Date range, Portfolio/property and Report source, then Run. For Custom dates, enter From and To before running the report.
Step 2: Refine the account and transaction scope
Use Advanced options when you need Book, Property, Unit, Account / category or Transactions filters. In the current register, the category selector starts with All Schedule E categories. Choose Income or Expenses only when appropriate, check Start date, End date and Report source, select Review on screen under Output, then Run report.
Step 3: Follow a P&L category to its transactions
In the Profit and loss report, select a linked category name, such as Rent. Rentari opens Account register with the category and report dates. Check the resulting dates, property and source, then compare the register total with the category you followed.
Step 4: Read the rows and check the download
Compare Account, Date, Description, Property address, Unit number, Tenant name and Amount with the records you are investigating. Open Download and choose an offered CSV, Excel workbook or PDF option. Open the file and check its filters, columns, line amounts and total against the report.
Step 5: Inspect recorded account entries
For Account activity, open Revenue in Accounting, then More and Account activity. Choose Bank account. Open Date range, enter From date and To date, then Apply. Inspect each entry’s Account, Debit and Credit lines. Use Export CSV for this activity view.
Step 6: Review the bank statement before locking
Open Accounts, find the correct account, open its three-dot menu and choose Reconcile. Enter Statement date, review Opening balance and enter Ending balance from the statement. Use Refresh rows after changing the statement date. Tick only the Cleared rows that appear on the statement and investigate the Difference. When the records are reviewed and the difference is zero, choose Lock the period and confirm the reconciled-through date and locked result.
Read the report source and date rules
Recorded ledger, including unpaid entries can include activity that has not been paid. Payments made and posted deductions uses a different source rule. Read the basis notice on the resulting report before comparing it with a cash-only statement.
The current register uses the recorded payment date when available and the transaction date otherwise. Its total belongs to the selected period and filters. Account activity instead shows recorded debit and credit lines; neither view is a live bank feed balance.
A report category, a bank account, a bookkeeping book and a property are different scopes. Confirm each selected value rather than assuming a shared name means the same records are included.
Recover from missing rows or a reconciliation difference
Check dates, property, category, bank account and source first. Review Import feed with Status set to Everything when an imported transaction seems missing. Compare possible duplicates and unbooked or ignored rows before booking anything; use the missing-bank-feed guide for that workflow.
In reconciliation, an empty ending balance keeps locking unavailable. A nonzero difference must be investigated. If you change Statement date, use Refresh rows before trying to lock. A prior lock can exclude older rows from a new review.
Compare the statement, opening balance and cleared rows. Do not create an unexplained expense or duplicate a transaction just to remove a difference. Ask your bookkeeper to resolve uncertain history or an incorrect prior reconciliation.
Check the result
- The register and activity views have the intended scopes, their rows can be traced to source records, and any downloaded file is checked. Reconciliation is confirmed separately only after the correct statement and cleared rows have been reviewed.
FAQs
Why does the register differ from my bank balance?
The register reports filtered transaction amounts, and the recorded source can include unpaid entries. Account activity and reconciliation use separate account and date scopes. Compare the same records with the statement; do not treat a register total as a live bank balance.
Does exporting or reaching a zero difference reconcile the account?
Exporting is only a download. A zero difference alone does not prove that the right rows or balances were used. Review the statement, confirm the cleared activity, and check the saved reconciled-through date after Lock the period.