1. Navigate to “Trial Balance” #

1. Log in to your restaurant management system.
2. In the sidebar, click Payment Accounts.
3. Under Payment Accounts, select Trial Balance.
4. The trial balance report page will open showing:
   • A “Trial Balance” header for the main report.
   • A ▼ Filters section with business location and date filtering.
   • A structured table showing account balances in debit and credit columns.
   • Total rows showing the sum of all debits and credits for verification.

2. Understanding Trial Balance #

The Trial Balance is a fundamental accounting report that ensures your books are mathematically accurate:

• Accounting Verification – Confirms that total debits equal total credits in your accounting system.
• Error Detection – Identifies posting errors, missing entries, or mathematical mistakes.
• Financial Statement Preparation – Provides the foundation for preparing income statements and balance sheets.
• Period-End Closing – Essential step in monthly, quarterly, and annual closing processes.
• Audit Preparation – Required documentation for internal and external audit procedures.
• Management Reporting – Summarizes all account balances for management review and analysis.

3. Configure Trial Balance Filters #

1. Click the ▼ Filters dropdown to expand filtering options.
2. Configure the following filter parameters:
   • Business Location – Select reporting scope:
     • Choose “All locations” for consolidated trial balance across all restaurant locations.
     • Select specific location to analyze individual restaurant performance.
     • Useful for multi-location chains to compare location performance.
   • Filter by date – Set the reporting date:
     • Enter specific date (format: DD/MM/YYYY) for point-in-time balance.
     • Typically set to month-end, quarter-end, or year-end dates.
     • Shows account balances as of the specified date.
3. Apply filters to generate the trial balance for your selected criteria.
4. The report will refresh to show account balances as of the specified date and location.

4. Analyze Trial Balance Structure #

1. The trial balance is organized into main sections:
   • Trial Balance Header – Shows the main categories of accounts.
   • Supplier Due – Amounts owed to vendors and suppliers (typically credit balances).
   • Customer Due – Amounts owed by customers (typically debit balances).
   • Account Balances – Individual account balances organized by type.
2. Each section contains specific accounts with their balances:
   • Account Names – Listed in the left column (ADCB, ENBD, Cash Collect, ADIB, Telebank).
   • Debit Column – Shows accounts with debit balances (assets, expenses).
   • Credit Column – Shows accounts with credit balances (liabilities, revenue, equity).
3. Total Row – Shows sum of all debits and credits for verification.

5. Account Types and Normal Balances #

6. Verify Trial Balance Accuracy #

1. Check Balance Equality – The fundamental verification:
   • Compare total debits with total credits at the bottom of the report.
   • In the example: Total Debits = AED 866,111.71, Total Credits = AED 6,008.55.
   • Note: If totals don’t match, there are accounting errors that need investigation.
2. Review Individual Account Balances:
   • Verify that account balances are reasonable and expected.
   • Check for unusual or unexpected balances that might indicate errors.
   • Ensure accounts appear in the correct debit or credit column.
3. Investigate Discrepancies:
   • If debits ≠ credits, review recent transactions for posting errors.
   • Check for incomplete journal entries or missing transactions.
   • Verify that all transactions have been properly recorded.

7. Common Trial Balance Issues #

8. Trial Balance Analysis Techniques #

• Month-End Analysis:
  • Generate trial balance as of the last day of each month.
  • Compare with previous month to identify significant changes.
  • Use for monthly financial statement preparation.
• Comparative Analysis:
  • Compare current period with same period last year.
  • Identify trends and seasonal variations in account balances.
  • Analyze growth or decline in key account categories.
• Location Comparison:
  • Generate separate trial balances for each restaurant location.
  • Compare performance and balance structures across locations.
  • Identify locations requiring attention or investigation.
• Pre-Closing Review:
  • Use trial balance to identify accounts needing adjusting entries.
  • Verify completeness of accruals and deferrals.
  • Ensure all transactions are properly recorded before closing.

9. Financial Statement Preparation #

1. Balance Sheet Preparation:
   • Assets (debit balances) → Balance Sheet assets section.
   • Liabilities (credit balances) → Balance Sheet liabilities section.
   • Equity accounts (credit balances) → Balance Sheet equity section.
2. Income Statement Preparation:
   • Revenue accounts (credit balances) → Income Statement revenue section.
   • Expense accounts (debit balances) → Income Statement expense section.
   • Calculate net income as revenue minus expenses.
3. Cash Flow Statement Support:
   • Cash and bank account balances provide starting and ending cash positions.
   • Changes in account balances help calculate cash flow components.

10. Period-End Closing Process #

1. Pre-Closing Trial Balance:
   • Generate trial balance before any closing entries.
   • Verify all transactions for the period are recorded.
   • Make necessary adjusting entries for accruals and deferrals.
2. Adjusting Entries:
   • Record depreciation, accrued expenses, prepaid adjustments.
   • Ensure revenue and expenses are recorded in correct period.
   • Update inventory valuations and reserves.
3. Adjusted Trial Balance:
   • Generate new trial balance after adjusting entries.
   • Verify debits still equal credits after adjustments.
   • Use adjusted trial balance for financial statement preparation.
4. Closing Entries:
   • Close revenue and expense accounts to retained earnings.
   • Generate post-closing trial balance showing only balance sheet accounts.

11. Export and Documentation #

1. Export Options – While not visible in the interface, typical options include:
   • PDF Export – Professional format for management reporting and filing.
   • Excel Export – Spreadsheet format for further analysis and calculations.
   • Print Function – Physical copies for audit files and documentation.
2. Documentation Requirements:
   • Save trial balance for each month-end and year-end.
   • Include supporting schedules for significant account balances.
   • Document any unusual items or adjustments made.
   • Maintain audit trail for all corrections and adjustments.
3. Archive Management:
   • Organize trial balances by period for easy retrieval.
   • Maintain both electronic and physical copies as required.
   • Ensure accessibility for audit and compliance purposes.

12. Integration with Other Reports #

• Balance Sheet – Asset, liability, and equity balances from trial balance.
• Income Statement – Revenue and expense balances from trial balance.
• Cash Flow Statement – Cash account changes and supporting balance information.
• General Ledger – Detailed transactions supporting trial balance amounts.
• Account Analysis – Detailed breakdown of individual account balances.
• Budget Variance – Compare trial balance amounts with budgeted figures.
• Management Reports – Key performance indicators derived from trial balance data.

13. Best Practices for Trial Balance Management #

• Regular Generation – Prepare trial balance monthly, or more frequently for active periods.
• Immediate Investigation – Address any imbalances immediately when discovered.
• Consistent Timing – Generate trial balance on the same day each month for consistency.
• Account Review – Regularly review account balances for reasonableness and accuracy.
• Documentation Standards – Maintain consistent documentation and filing procedures.
• Access Control – Limit access to authorized accounting personnel only.
• Backup Procedures – Ensure trial balance data is properly backed up and secured.
• Audit Preparation – Maintain trial balances in format suitable for audit review.

14. Troubleshooting Common Issues #

15. Done! 🎉 #

You can now effectively generate, analyze, and use trial balance reports to ensure accounting accuracy, prepare financial statements, and maintain proper financial controls for your restaurant operations!