What Is A List Of Accounts And Their Balances At A Given Time Called?

What’s going on here?

Every transaction in the ledger has to keep that accounting equation balanced (Assets = Liabilities + Equity)AccountingTools, so debits must always match credits. Over time though, even small mistakes—like a typo when entering data, rounding errors, or accidentally deleting a transaction—can throw things off. The trial balance lists every account—Cash, Accounts Receivable, Revenue, Expenses, you name it—with its ending debit or credit balance. When those two columns don’t match, it’s like a red flag waving before you finalize your income statement or balance sheet. Honestly, this report is a lifesaver right before closing a financial period or when you’re about to share statements with investors or auditors.

According to the IRS, maintaining accurate trial balances is essential for tax compliance and financial transparency.

How to actually create one

Here’s exactly where to find it on different platforms as of 2026:

QuickBooks Desktop 2026 (R15 or later)

1. Sign in with an “Accountant” user role—this unlocks all the reporting tools you need.
2. Head to Reports → Accountant & Taxes → Trial Balance.
3. Set the report date to the last day of your period (say, March 31, 2026).
4. Look at the totals at the bottom. If they don’t match, click “Exceptions Report” to see which accounts are out of whack.
5. Click the mismatched amount to pull up the original journal entry. Fix the debit or credit, then save your changes.
6. Run the trial balance again. Keep tweaking until both columns match perfectly.

QuickBooks Online (as of 2026 Q2)

1. Go to Accounting → Chart of Accounts.
2. Click “Run Trial Balance” in the top right corner.
3. Set the End Date to the last day of your reporting period.
4. If the totals don’t line up, click the mismatched amount to see the original transaction. Edit it, then save.
5. Hit “Refresh” to regenerate the report. Repeat until debits equal credits.

Xero (2026.3 or later)

1. Navigate to Reports → Accounting → Trial Balance.
2. Set the Report Date and click “Update”.
3. Export the report to Excel using Export → CSV, then sort by the difference column to spot the problem account fast.
4. Head to Accounting → Journal Entries, find the entry tied to the out-of-balance account, correct the number, save, and run the trial balance again.

Still not balanced? Here’s what to do next

• Restore and Re-enter

  When the file’s corrupted or you can’t trace the imbalance, pull up the most recent backup that balanced correctly. Then re-enter only the transactions from the problematic period. QuickBooks Desktop users should always keep an external backup from the last month-end close, and cloud users need to double-check their 30-day rolling backup settings.

• Investigate Reconciliation Gaps

  Often, imbalances come from uncleared bank or credit-card transactions. Use the Reconciliation Discrepancy Report (QuickBooks Desktop: Reports → Banking → Reconciliation Discrepancy; QuickBooks Online: Gear → Reconciliation → History by Account) to find transactions incorrectly marked as cleared. Pay close attention to items dated after the reconciliation date—these usually cause carryover errors.

• Fix Imported Data Issues

  Automated bank or payment processor imports can mess things up with duplicates or split transactions. Turn off auto-import temporarily, delete the problematic entries, and re-import only the cleared transactions. Make it a habit to review imported data regularly so formatting glitches don’t slip through.

For further guidance, the AccountingTools guide on trial balances provides additional troubleshooting steps.

Stop discrepancies before they start

The Financial Accounting Standards Board (FASB) emphasizes the importance of accurate financial reporting, including trial balance integrity, for regulatory compliance.

What’s Happening

The trial balance is your first warning: it lists every account (Cash, Accounts Receivable, Revenue, etc.) and the net debit or credit balance as of the report date. When the two column totals don’t match, you know something’s wrong before it messes up your income statement or balance sheet.

Step-by-Step Solution

QuickBooks Desktop 2026 (R15 or later)

1. Open the file and log in with an “Accountant” role.
2. Navigate to Reports → Accountant & Taxes → Trial Balance.
3. Pick the date—set it to the last day of the period you’re checking (e.g., 2026-03-31).
4. Look at the totals at the bottom. If debits ≠ credits, click “Exceptions Report” to see the exact mismatches.
5. Dig into the first mismatch; the software opens the underlying journal entry. Edit the amount or account, then save.
6. Re-run the trial balance. Repeat until the two columns match exactly.

QuickBooks Online (as of 2026 Q2)

1. Head to Accounting → Chart of Accounts.
2. Click “Run Trial Balance” in the top right.
3. Set the End Date to the last day of the period.
4. If the totals don’t match, click the mismatched amount—you’ll see the original transaction. Fix it and re-save.
5. Click “Refresh” to regenerate the report. Keep going until debits = credits.

Xero (2026.3 or later)

1. Go to Reports → Accounting → Trial Balance.
2. Pick the Report Date and click “Update”.
3. When totals are off, export the report to Excel (Export → CSV) and sort by the difference column to spot the problem account fast.
4. Jump to Accounting → Journal Entries, find the entry that changed the out-of-balance account, correct the figure, save, and re-run the trial balance.

If This Didn’t Work

• Backup & Restore

  If the file is corrupted or the error is untraceable, close the file and restore the most recent backup that did balance. Re-enter only the transactions from the month(s) since the backup. Most accounting software keeps a 30-day rolling backup; QuickBooks Desktop users should have an external copy from their last month-end close.

• Account Reconciliation Audit

  Mismatches often hide in uncleared bank or credit-card transactions. Run the Reconciliation Discrepancy Report (QuickBooks Desktop: Reports → Banking → Reconciliation Discrepancy; QuickBooks Online: Gear → Reconciliation → History by Account). Watch for transactions marked as cleared but dated after the reconciliation date—those throw off the next period.

• Third-Party Import Fix

  If you use bank-fetch or PayPal imports, turn off auto-import, delete the bad entries, and re-import only the cleared items. Many import glitches create phantom “Split” lines that unbalance the ledger.

Prevention Tips

Stick to these steps every month and your books stay balanced—no last-minute chaos required.