📊 Comparative Account Analysis - User Guide

🎯 Overview

This powerful analysis tool provides:

• Side-by-side comparison of account balances at two different points in time
• Balance Sheet accounts shown cumulatively (all transactions up to each date)
• Profit & Loss accounts shown year-to-date (January 1st to each date)
• Variance calculations showing both amount and percentage changes
• Flexible filtering by job, location, account status, and balance

🚀 Getting Started

1 Open the Form

Navigate to Accounts → Comparative Account Analysis from the main menu.

2 Select Your Dates

What the dates mean:

• For Balance Sheet Accounts: Shows cumulative balance of ALL transactions up to and including the selected date
• For P&L Accounts: Shows year-to-date balance (January 1st through the selected date)

3 Apply Filters (Optional)

Filter	Description	When to Use
Job	Filter transactions by specific job/project	Analyze performance of a particular project or job
Location	Filter transactions by store/warehouse location	Compare performance across different locations
☐ Inactive	Include accounts marked as inactive	Review historical or closed accounts
☐ Zero	Include accounts with zero balance in both periods	See complete chart of accounts, including unused accounts

4 Click Go

The system will generate your comparative analysis showing all relevant accounts with their balances and variances.

📋 Understanding the Results

Column Descriptions

Column	Description
Account Number	The unique identifier for each account
Account Name	The descriptive name of the account
Account Type	Classification (Bank, AR, Expense, Revenue, etc.)
Report Section	BS (Balance Sheet) or PL (Profit & Loss)
Date 1 - Debit	Debit balance for the first selected date
Date 1 - Credit	Credit balance for the first selected date
Date 1 - Net Balance	Net balance (Debit - Credit) for Date 1
Date 2 - Debit	Debit balance for the second selected date
Date 2 - Credit	Credit balance for the second selected date
Date 2 - Net Balance	Net balance (Debit - Credit) for Date 2
Variance Amount	Change in net balance (Date 1 - Date 2)
Variance %	Percentage change from Date 2 to Date 1

Interpreting Variances

✨ Key Features

Grouping & Sorting

The grid supports:

• Group By: Drag column headers to the group area to organize accounts by Account Type, Report Section, etc.
• Sorting: Click any column header to sort (click again to reverse)
• Multi-column Sort: Hold Shift and click multiple headers

Filtering

Use the filter row at the top of the grid to narrow down results:

• Type in any filter cell to search that column
• Filter by account number, name, type, or any other field
• Combine multiple filters for precise results

Summary Totals

At the bottom of the grid, you'll see grand totals for:

• Date 1 Debit, Credit, and Net Balance
• Date 2 Debit, Credit, and Net Balance
• Total Variance Amount
• Record Count

📊 Common Use Cases

1. Year-over-Year Comparison

Purpose: Compare your financial position between two fiscal year ends to track annual growth and changes.

2. Month-over-Month Analysis

Purpose: Track short-term trends and monthly performance variations.

3. Quarter-end Comparison

Purpose: Analyze quarterly performance and identify seasonal patterns.

4. Budget vs. Actual (with Job Filter)

Purpose: Track project performance year-over-year for specific jobs.

5. Location Performance Comparison

Purpose: Analyze individual location performance over time.

🔍 Drill-Down Analysis

Future enhancement: Double-click any account row to view detailed transactions for that account within the selected date ranges.

💾 Exporting Data

You can export the comparative analysis to:

• Excel: For further analysis and custom calculations
• PDF: For printing and sharing with stakeholders
• CSV: For importing into other systems

⚙️ Advanced Tips

Finding Large Variances

1. Click the "Variance %" column header to sort by percentage change
2. Review accounts with the largest positive or negative changes
3. Investigate any unexpected variances

Focusing on Material Accounts

1. Leave "Zero" unchecked to hide accounts with no activity
2. Use the filter row to show only accounts above a certain threshold
3. Example: In "Date 1 - Net Balance" filter, type ">10000" to show only accounts with balance over $10,000

Identifying Inactive Account Activity

1. Check the ☑ Inactive checkbox
2. Sort by "Account Number" or "Account Name"
3. Review if any inactive accounts have recent activity

❓ Frequently Asked Questions

Q: Why are some accounts showing zero variance when I know there were transactions?

A: For P&L accounts, the system shows year-to-date balances. If both dates are in the same year, the variance only reflects changes between those specific dates, not cumulative changes. For Balance Sheet accounts, ensure you're comparing dates within the correct fiscal periods.

Q: What's the difference between Balance Sheet (BS) and Profit & Loss (PL) accounts?

A:

• Balance Sheet (BS): Assets, Liabilities, Equity - shows cumulative balance up to each date
• Profit & Loss (PL): Revenue, Expenses, COGS - shows year-to-date balance (Jan 1 to each date)

Q: Why is the Variance % blank for some accounts?

A: When Date 2 has a zero balance, the percentage change cannot be calculated reliably because QBM cannot divide by zero. This is shown as blank rather than displaying a misleading value.

Q: Can I compare dates from different fiscal years?

A: Yes! The system handles cross-year comparisons correctly. P&L accounts will show year-to-date for each respective year, while Balance Sheet accounts show cumulative balances.

Q: How do I save my filter and grouping preferences?

A: The grid automatically saves your layout preferences (column order, widths, grouping, etc.) when you close the form. They will be restored the next time you open it.

🛠️ Troubleshooting

Issue	Solution
Grid is empty after clicking Go	Check if "Zero" checkbox is unchecked - try checking it Verify your Job/Location filters aren't too restrictive Ensure there are transactions in the selected date range
Numbers don't match other reports	Verify you're comparing the same date ranges Check if Job/Location filters are applied consistently Ensure "Inactive" checkbox matches your expectations
Form is slow to load	Try applying Job or Location filters to reduce dataset Uncheck "Zero" and "Inactive" to show fewer records Close other open forms to free up resources
Can't see all columns	Scroll horizontally using the bottom scrollbar Resize columns by dragging column borders Right-click the grid and choose "Column Chooser" to show/hide columns