CASE STUDY

THE STORY OF A LITTLE BAR WITH A LITTLE MONEY

OVERVIEW
Once upon a time in the Pacific Northwest, there was a new bar; just opened in October. The build-out ran over budget and time. Cash flow was very tight. This new bar was part of a larger organization with centralized upper level management and back office support, including accounting.

Day to day operations were run by the Chef and the General Manager (GM). They would make purchases by debit card and check. As a start-up they had to pay cash for all liquor, beer and some food deliveries. They used a point of sale system called Toast.

On Tuesday afternoons, the GM would collect the prior week's accounting paperwork and deliver it to the main office. The accounting staff would record the transactions, usually on Friday mornings in QuickBooks Desktop.

The cash on hand was never current. Upper level management didn't know what cash was available and struggled to make payroll and pay bills. Paperwork received in the main office would be up to 12 days old by the time it was recorded. There was always an unknown number of purchases in the current week.

The accounting system involved manually entering all transactions. It was inefficient and prone to data entry errors. Checks would be printed on check stock, signed, stapled, stuffed and mailed. Then came the filing....yuck!

bar image.png

CHALLENGES

  • Know our sales. We needed to know what was sold yesterday. Sales needed to be recorded and monitored every day.

  • Know our spending. Without knowing what the GM or Chef purchased, we had zero confidence in the cash on hand.

  • Physical limitations. This little bar is 1300 miles away. We were never going to be physically present on Tuesdays.

  • Payment limitations. We were not going to be able to print, stuff, staple, and mail checks. And we don't like to file paperwork!

SOLUTIONS

We moved the accounting to QuickBooks Online. With a third party app, Shogo, we linked the point of sale to it. Sales are entered automatically, every day.

We setup the QuickBooks Online and Bill.com apps for the GM and Chef. Using the apps, they take a picture of their receipt or vendor invoice. It uploads to a holding place in the software within minutes.

Using AI and OCR, QuickBooks Online and Bill.com creates the transaction for review and approval. 1300 miles away, we review and record transactions. Weekly we initiate ACH payments to vendors.

We always know the cash on hand. And never file paperwork again.

cheers.png

RESULTS

  • 100% of yesterday’s transactions recorded and analyzed

  • 16 accounting staff hours saved