• Home
  • Services
    • Accounting Services
    • Bookkeeping
    • Payroll
    • Cash Flow Forecast
    • Consulting for QuickBooks®
    • Training for QuickBooks®
    • Xero Cloud Accounting
    • Cloud Accounting
    • Sales Document Automation
  • Resources
    • Resources
    • Mobile Accounting
  • Blog
  • About
    • About
    • Send Us Your Referrals
  • Contact
1 (760) 573-1038
info@strategic-ba.com
September 3, 2015

Your Daily Numbers

Ken Aurigemma Accounting, Profitability Tips

Tweet
Share
Share
Pin

Some numbers need reviewing on a daily basis, and one example of this is cash.  When cash is coming in from a number of places, it’s great to have a daily summary of what was collected.

It’s also great to make sure all the collections hit your bank account so you can feel confident that no errors were made along the way.  A daily cash reconciliation report will serve both needs very well.

A daily cash report will vary depending on the type of business you have, but it will look like a combination of a bank reconciliation and a sales report wrapped into one.

If you are managing your cash closely from day to day, then this report will help you stay sane.  You’ll need two very brief spreadsheets to get started.  The first one below is your daily sales from all sources.  Your accounting system may be able to generate this.

Today’s Sales
Cash $300.00
Checks $600.00
Total Bank Deposit $900.00
Mastercard Visa $400.00
American Express $200.00
Total Credit Card Due $600.00
PayPal $100.00

If your accounting system is up to date, all you’ll need to do is pull the cash balance and adjust for today’s activity.  The following day, you can double check your accuracy and adjust accordingly using the last two rows.

Daily Cash Report
Book Cash Balance $5,000.00
Deposit from Today’s Sales $900.00
Merchant Deposit $600.00
Less Checks Written Today ($1,200.00)
$5,300.00
Expected Bank Balance Tomorrow $8,300.00
Actual Bank Balance $8,300.00
Explain any differences

If your accounting system is not updated in real time, you’ll need to start with the bank balance and correct it for uncleared transactions as well as list today’s activity.

Daily Cash Report
Bank Balance $5,000.00
Deposit from Today’s Sales $900.00
Merchant Deposit $600.00
Less Checks Written Today ($1,200.00)
$5,300.00
Checks Still Outstanding ($3,000.00)
Deposit from A/R Paid $5,000.00
Expected Bank Balance Tomorrow $8,300.00

 

Using these formats, you can easily extend them to cover the entire week.  This way, you’ll know what your cash balance will be from day to day.

If you see the value of this report for your business and would like help creating it, please reach out.

Tweet
Share
Share
Pin
Cool Tech Tools: When There’s No Internet, Use Your Personal Hotspot Attract More Customers with Event Marketing

Related Posts

Blog, Business Growth, Business Tips, Profitability Tips

Ten Places to Look to Find More Profits

Accounting, Blog, Business Tips, News

PPP January 2021 Update

Accounting, Business Development, Business Growth, Business Tips, Decision-Making Tips

The Entrepreneur’s Guide to Starting a Business in 12 Easy Steps

Recent Posts

  • Fighting Cybersecurity Threats in Your Business
    February 25, 2021
  • The Concept of Independence in Accounting
    February 11, 2021
  • Ten Places to Look to Find More Profits
    January 27, 2021

Latest Tweets

→ Follow me
  • Home
  • Services
  • Resources
  • Blog
  • About
  • Contact

Contact Us

Payroll Services, Accounting Services and Services for QuickBooks®

Strategic Business Alliance, LLC

6132 Innovation Way
Suite 102
Carlsbad, CA 92009

1 (760) 573-1038

info@strategic-ba.com

Client Login


Intuit, QuickBooks, and QuickBooks ProAdvisor are registered trademarks of Intuit Inc. Used with permission under the QuickBooks ProAdvisor Agreement.
Copyright Strategic Business Alliance 2020 | Site Design by Accelerator Websites