When you look at the financial statements, your objective should be to determine within one minute whether the company is making profits or not, and whether the revenues and expenses are in line with standards prescribed by the accounting bodies of the US.
How do you prepare the reports that give you the exact state of your business?
1. It all starts with your company’s chart of accounts.
Astonishingly, many new clients whom we work with use a very generic chart of accounts. These generic Chart of accounts usually created to ease the process of calculating year-end tax returns. But while these chart of accounts are advantageous in calculating taxes, they contribute very little in the way of management reporting. For QSR business, specific chart of account is needed to depict an exact snapshot of your business, the chart of account can be different for the other industries.
2. Classification of sales:
Classification of sales is very necessary as sales tax is a calculated as a percentage of taxable sales and not on net sales. Therefore, verifying the percentages becomes difficult if we record the net sales. Therefore, it is suggested to record Taxable Sales and Non-Taxable sales separately so that we can reconcile Sales Tax figures as well.
3. Group expenses by cost type.
Cost categories include:
4. Calculate the gross profit/margin.
Direct costs deducted from sales will give you the gross margin. By looking at the gross margin, you can determine whether you are operationally efficient. It tells you if you have generated enough sales volume to cover your fixed costs, and allow you to show a reasonable profit.
5. Compute variances with standard.
Once the management report is set up with actuals vs. the benchmark column, it is important to see how the actual results match up with benchmark. Here we recommend a column showing the variance which will eventually allow you to ask questions about why your company may or may not be measuring up to the benchmark or this year’s budget.
Producing a “One minute management report” that meets its objectives using these steps is not at all difficult. Accounting programs are easily adapted to generate financial statements that meet these criteria.
Fruxient Accounting specializes in restaurant accounting and our Team lead Gaurav, is a competent certified public accountant (CPA) who can help you set up a program and can assist you to maintain your books of accounts with QuickBooks online which is equipped to produce one-minute reports.
Here’s a snapshot of the report (Source – Client having 2 locations of Roy Rogers- Data for Dec 20) :
Sales Data Recap | ||
Sales | 270708.34 | 100% |
Total Sales | 270708.34 | 100% |
Labor Cost data | Labor Distribution | |
Management | 32455.01 | 33% |
Supervisors | 6646.44 | 7% |
Associates/Staff | 58204.21 | 60% |
Total Gross Payroll | 97305.66 | 100% |
Payroll tax Burden | 6845.32 | |
Total Labor Cost | 104150.98 | |
Labor Cost % Total | 38% |
P& L Date | ||
Net Sales | 262244.7 | 100% |
Cost of Sales | 94035.57 | 36% |
Gross Profit Margin | 168209.1 | 64% |
Labor Cost | 64850.65 | 25% |
GPM Before OH | 103358.5 | 39% |
Prime Cost Percent: | ||
Food-Paper-Labor % of Sales | 61% |
Food Data | |
Beg. Inventory | |
Food | 5662.02 |
Paper | 0 |
Product Purchased | |
Food | 78508.37 |
Paper | 13074.08 |
Available Product | |
Food | 84170.39 |
Paper | 13074.08 |
End. Inventory | |
Food | 4207.88 |
Paper | 0 |
WhatsApp us