A-List Accounting, LLC
850-807-0355
info@alistaccounting.com
  • Home
  • Services
    • Accounting Services
    • Business Consulting Solutions
    • What Is Outsourcing?
    • Bookkeeping
    • Payroll
    • Cloud Accounting
    • Tax Preparation and Planning
    • Tax Resolution
  • QuickBooks and Xero Consulting
    • Consulting for QuickBooks®
    • Training for QuickBooks®
    • QuickBooks Products
    • Xero Cloud Accounting
    • Xero Training
  • Industries
    • Services
    • Construction
    • Medical and Health Care
    • Real Estate
    • Non Profit
    • Retail
    • Restaurant
    • Manufacturing
    • Wholesalers and Distributors
    • eCommerce
  • Testimonials
    • Testimonials
    • Post a Review
  • Resources
  • Blog
  • About us
  • Career Opportunities
  • Contact
  • Home
  • Services
    • Accounting Services
    • Business Consulting Solutions
    • What Is Outsourcing?
    • Bookkeeping
    • Payroll
    • Cloud Accounting
    • Tax Preparation and Planning
    • Tax Resolution
  • QuickBooks and Xero Consulting
    • Consulting for QuickBooks®
    • Training for QuickBooks®
    • QuickBooks Products
    • Xero Cloud Accounting
    • Xero Training
  • Industries
    • Services
    • Construction
    • Medical and Health Care
    • Real Estate
    • Non Profit
    • Retail
    • Restaurant
    • Manufacturing
    • Wholesalers and Distributors
    • eCommerce
  • Testimonials
    • Testimonials
    • Post a Review
  • Resources
  • Blog
  • About us
  • Career Opportunities
  • Contact

Your Daily Numbers

September 3, 2015 In Accounting, Profitability Tips

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.

Leave your comment Cancel Reply

(will not be shared)

Monthly Archives

Categories

  • Accounting (56)
  • Accounting Software (1)
  • Blog (10)
  • Bookkeeping (1)
  • Bookkeeping Tips (22)
  • Business Development (61)
  • Business Growth (6)
  • Business Tips (195)
  • Cloud Accounting (2)
  • Cool Tech Tools (21)
  • Cost-Saving Tips (1)
  • Cost-Savings Tips (16)
  • Customer Service (1)
  • Customer Service Tips (19)
  • Decision-Making Tips (7)
  • Expense Reduction Tips (10)
  • Finance Management (1)
  • Management Tips (50)
  • Marketing Tips (1)
  • Money Management (1)
  • Payroll Tips (6)
  • Personal Development (5)
  • Productivity Tips (1)
  • Profitability Tips (31)
  • Profits (1)
  • QuickBooks Help (2)
  • QuickBooks Software (2)
  • QuickBooks Training (1)
  • Small Business (1)
  • Social Media (5)
  • Tax (5)
  • Technology (1)
  • Time Management Tips (20)
  • Uncategorized (2)

Sitemap

  • Home
  • Accounting Services
  • QuickBooks and Xero Consulting
  • Industries
  • Testimonials
  • Blog
  • About Us
  • Career Opportunities
  • Contact

Contact Us

Consulting & Training for QuickBooks, Consulting & Training for Xero, Bookkeeping, Payroll, Taxes and CFO/Controller services

A-List Accounting, LLC

PO Box 9517, Panama City Beach, FL 32417

850-807-0355 | info@alistaccounting.com

Client Login

Client Portal Login


Intuit, QuickBooks, and QuickBooks ProAdvisor are registered trademarks of Intuit Inc. Used with permission under the QuickBooks ProAdvisor Agreement.

Copyright A-List Accounting, LLC 2022 | Professional Site Design by Accelerator Websites | Powered By ThriveFuel