Revenue
Sales Revenue
coffee sales	396000
retail sales	67400
dessert sales	71500
food sales	65100
bottled drinks	24000
bean sales	134500
Net Sales	758500
Other Revenue	3218
Total Revenue	761718
Expense
Cost of Goods Sold
coffee purchases	164280
inventory Supplies	22600
Retail Purchases	21400
Dessert Purchases	37800
Food Purchases	20600
Bottled Drinks	9300
Total COGS	275980
Payroll Expenses
Wages and Salaries	202000
Gov't Payroll Taxes	7530
Employee Benefits
Total Payroll Expense	209530
General & Administration Expense
Accounting & Legal	2400
Advertising & Promotions	4800
Bad Debts	400
Business Fee & Licenses	550
Cash Short/Over	-750
Courier & Postage	825
Credit Card Charges	265
Currency Exchange
Amortization Expense	12000
Equipment Lease	14400
Income Taxes
Insurance	7200
Interest & Bank Charges	2400
Office Supplies	960
Property Taxes
Professional Services	1400
Motor Vehicle Expenses	5900
Misc Expenses	800
Rent	36500
Repair & Maintenance	9600
Secruity	1200
Telephone & Internet	3600
Training	4000
Travel & Entertainment	9000
Utilities	7200
Total General & Administration	124650
Total Expense	610160
Net Income	151558

If you are an independent restaurant owner or just a restaurant operator struggling to keep your restaurant accounting in order, we have put together an easy to use and FREE downloadable profit and loss excel template. Customizable document templates containing example content and sample financial figures provide a quick and affordable way of creating a high-quality professional business plan and accompanying documents for a Coffee Shop. The Coffee Shop BizDoxBox™ contains a full set of business planning template documents for a company that will be. No matter how efficiently your coffee shop runs, you will still fail if you don’t have a sufficient profit margin per item or a menu that draws in customers. According to Chris, it’s essential that your shop offers variety – but not so much that you end up sacrificing quality.

Coffee Shop Bookkeeping Spreadsheets 2022 year end

Coffee Shop Profit And Loss Template Pdf

Easy-to-use bookkeeping spreadsheets for coffee shops. This set of coffee shop accounting templates including flat rate VAT, cash accounting VAT & non-VAT versions will simplify your coffee shop bookkeeping, VAT return and 2022 year end coffee shop accounts preparation.

Simple coffee shop accounting spreadsheets include instructions
For financial year ending in 2022 (financial year end date can be changed to any date in 2022)
NO bookkeeping experience required, simply record till sales, bankings & payments/expenses
VAT page will automatically calculate the coffee shop VAT due for each quarter
The layout, formulas & also the 'predictive text' feature of Excel will help reduce the time you need to spend on your coffee shop bookkeeping
Coffee shop expenses sheet contains drop-down menus makes categorising expenses very quick & straightforward
Provides you with a detailed coffee shop trading profit & loss account
3 spreadsheets are included: one designed for the special flat-rate retail VAT scheme, one for the retail cash VAT scheme and one for non-VAT registered coffee shops

VAT data can be submitted to HMRC under the new MTD system using bridging software, such as the system available from www.vitaltax.uk
Pages include :

Daily coffee shop takings
Bank & cash receipts
coffee shop expenses sheet
Profit & Loss account (automatically generated)
Quarterly VAT return summary (automatically calculated)

Simple coffee shop accounts software for less than the price of a meal!!

Watch Video Demo of Similar Accounts Spreadsheet

Customer comments:

'just the job - saved a lot of time and effort!'

'this will make life so much easier thanks'

'Fantastic, absolutely perfect time saver'

'good software, really helpfull, thanks”

'all you need to make your life simple'

'Great product- makes my life easier.'

Coffee Shop Profit And Loss Template For Small Business

'Looks simple enough, bit like me ?'

'Exactly, what it says on the tin !!'

Coffee Shop Profit And Loss Template For Self Employed

'should be ideal thank you'

Coffee Shop Profit And Loss Template Printable

'great item, bargain deal'

'VERY good product'

'very good - tip top'

'good value'

All spreadsheets are designed using Microsoft Excel 2003, and will run on all later versions of Excel.
If you do not have Microsoft Excel, then the spreadsheets are compatible with the FREE OpenOffice software, available from www.openoffice.org