Coffee

Coffee Shop Bookkeeping Spreadsheets 2020 year end


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 2020 year end coffee shop accounts preparation.

If anything, your accountant can provide an actual profit/loss, cash flow, and balance sheet you can use for your business. I used a downloadable template from “Start & Run A Coffee Bar,” Matzen & Harrison that combined the revenue, profit/loss and cash flow projections in a spreadsheet. Built for coffee shops specifically — our coffee shop template allows you to build a model that is built around the number of customer tickets per month and the average customer spend per order. It allows you to add both food and drink options as well as merchandise sales. The idea is to attract as many people as possible to our coffee shop. In view of this, our annual projected sales for Coffee4All® is put at about $500,000 annually which translates into $254.00 of sales per square foot. This is in line with the industry averages for this size of coffee shop in the united states of America. If anything, your accountant can provide an actual profit/loss, cash flow, and balance sheet you can use for your business. I used a downloadable template from “Start & Run A Coffee Bar,” Matzen & Harrison that combined the revenue, profit/loss and cash flow projections in a spreadsheet.

  • Simple coffee shop accounting spreadsheets include instructions
  • For financial year ending in 2020 (financial year end date can be changed to any date in 2020)
  • 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

  • Updated to record temporary hospitality reduced VAT rated income

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!'

Coffee Shop Profit And Loss Template

'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.'

'Looks simple enough, bit like me ?'

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

'should be ideal thank you'

'great item, bargain deal'

'VERY good product'

'very good - tip top'

'good value'

Coffee

Click here for Coffee Shop Accounting & VAT Spreadsheets for 2016 year ends

Click here for Coffee Shop Accounting & VAT Spreadsheets for 2018 year ends


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

Coffee Shop Bookkeeping Spreadsheets 2022 year end


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!!

Coffee Shop Profit And Loss Template


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.'

'Looks simple enough, bit like me ?'

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

'should be ideal thank you'

'great item, bargain deal'

'VERY good product'

Coffee Shop Profit And Loss Statement

'very good - tip top'

'good value'

Coffee Shop P&l Statement

Profit

Coffee Shop Profit And Loss Template Excel


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