Total Outstanding Payments/Receipts. Transactions that were entered into Xero, but not yet reconciled. Total Unreconciled Statement Lines. Transactions imported from your online bank account (at the report date) that are not yet reconciled (or possibly not yet entered) in Xero.
Tip
- View the bank reconciliation details for the statement line.
- Click the account transaction on the right to open it.
- If the statement line is matched against a spend or receive money transaction instead of an invoice or bill payment, click Options, then select Remove & Redo to delete the payment.
Click the
Recode arrow, then select
Recode source transactions or
Recode with a manual journal. Enter the changes you want to make.
To start recoding, find the group of transaction lines that match one or more conditions.
- In the Accounting menu, select Advanced, then click Find and recode.
- Click Find and recode.
Refund a customer overpayment
- In the Business menu, select Invoices.
- Select the Awaiting Payment tab.
- Find and open the overpayment you want to refund.
- Scroll down to Make a cash refund and complete the payment fields.
- Click Add Refund.
Hi Lynn - I know it's not your exact request here, but you can already sort by 'Status' in the account transactions list of a bank account. This might help to group and see the unreconciled transactions together. Just click on the column header, or double-click to reverse.
There isn't a reset option that will remove all your data in one step. To start again, you'll need to export your data individually, add a new organisation, and then import your data into the new organisation.
Here's how:
- Go to Accounting tab on the left panel.
- Under Your Company, select Chart of Accounts.
- Choose the account you're working on, and click on View Register.
- Select the transactions you want to unreconcile.
- Keep on clicking the R status until it shows blank or cleared (C).
- Click on Save.
Only unreconciled statement lines appear on this screen.
- In the Accounting menu, select Bank accounts.
- Click Reconcile [x] items for the bank account you want to delete the statement line from.
- For the bank statement line you want to delete, click Options, then select Delete statement line.
- Click Yes to confirm.
Remove and Redo will remove the accounting transaction in Xero for the supplier payment and the purchase invoice will become “unpaid”. Hence the need to “Redo” the reconciliation of the bank statement line in order to recreate the supplier payment in Xero.
From an invoice or bill
- In the Business menu, select Invoices or Bills to pay.
- Select the Paid or Awaiting Payment tab.
- Find and open your paid or partly paid invoice or bill.
- Click the blue Payment link in your invoice or bill. If you're using new invoicing, click Less payment.
- Click Options, then select Remove & Redo.
You'll need to reconcile this against the bank statement line for the refund paid.
- On the bank reconciliation screen, next to the bank statement line you want to reconcile, click Find & Match.
- Find and select the checkbox next to the credit that you want to match with the bank statement line.
- Click Reconcile.
If you spot a duplicate statement line, click the date in the Date imported into Xero column. Select the checkbox next to the transaction, then click Delete.
The statement balance in Xero is the opening bank balance plus the sum of all bank statements imported into the bank account in Xero. You can import bank statements manually, or by using a feed. The balance in Xero is the opening bank balance plus the account transactions created in the bank account in Xero.
QuickBooks Errors & Solutions: How to Fix Reconciliation Discrepancies?
- First of all, click Reconciliation Discrepancy after choosing Banking from the Reports menu.
- Then choose the right account and click on Ok.
- Go through the report in order to find a discrepancy.
Do a mini-reconciliation to correct the Beginning Balance in the Begin Reconciliation window.
- Go to the Banking menu, then select Reconcile.
- Select the appropriate account from the Account drop-down.
- Enter the statement date and ending balance that match your Journal Entry.
- Select Continue.
Go to the Banking menu and select Reconcile. Select the Account drop-down then choose the account you want to reconcile. In the Statement Date field, choose the date from the financial statement you selected. In the Ending Balance field, enter the ending balance from your statement.
Checkmark = the transaction has been Entered, Verified, marked as Cleared and the Reconciliation was Completed.
When you reconcile, and tell QB to make an adjustment, QB creates an expense account titled reconciliation discrepancy and posts the adjustment to that.
The 3 below statements are true:
- Bank rules can be prioritized.
- Bank rules can be copied, edited, or deleted.
- You can automatically add transactions to the register using Bank Rules.
Use the audit log to re-enter deleted transactions
- Select Settings ⚙?.
- Select Audit Log.
- From the Filter ? drop-down menu, select the appropriate user, date, and event(s).
- Select Apply.
- Locate the deleted transaction.
- Under the History column, select View.
- All the information needed for the transaction can be found under the Event column.
Just like balancing your checkbook, you need to do this review in QuickBooks. You should reconcile your bank and credit card accounts in QuickBooks frequently to make sure they match your real-life bank accounts.
