Democratic Underground Latest Greatest Lobby Journals Search Options Help Login
Google

Small business - cash flow and budgeting

Printer-friendly format Printer-friendly format
Printer-friendly format Email this thread to a friend
Printer-friendly format Bookmark this thread
Home » Discuss » DU Groups » Economy & Jobs » Small Business Owners & Entrepreneurs Group Donate to DU
 
matt819 Donating Member (1000+ posts) Send PM | Profile | Ignore Wed Sep-08-10 06:32 PM
Original message
Small business - cash flow and budgeting
The usual small business issue here. Cash flow management. Cash flow reporting in QuickBooks is pretty poor, and I'm having no better luck with third party software that imports QB data. I have 200+ income and expense line items, though, of course, not all show activity in any given week. And then there are the usual household expenses - mortgage, insurance, food, gas, etc.

Spouse tells me to do it by hand (surely it can't be that hard, I'm advised). Maybe I'm overthinking this. Anyone with advice?
Refresh | 0 Recommendations Printer Friendly | Permalink | Reply | Top
earcandle Donating Member (1000+ posts) Send PM | Profile | Ignore Sat Sep-11-10 05:12 PM
Response to Original message
1. When I am working my day job, I do accounting for small businesses , some of which
generate income in six digits.

On a daily basis I offer the owners of one company the following so they know actually what is in process and what is on hold. All payables are paid, and some checks are released and some on hold. I also note projections that I haven't written checks for yet but are coming up. I call it a cash rec and it is on an excel sheet.

It has top left a (now) formula so everyday it captures the date of the report.

Also on the left is cash in bank: a copy of the bank statement for the day is included in the cash rec attachments
Also on the left are deposits in transit that have not yet hit the bank
Also on the left are a deduction for checks released
Also on the left are a deduction for checks on hold
Each section has a total after each deduction.

Amount of cash after deposits in transit clear.
Amount of cash after released checks clear.
Amount of cash after holds clear

On the right are checklists and projections lists in groups with totals linked to the left side:
Checks released and Checks on Hold and Projections coming up.

I also include a ,pdf of the Quickbooks checkbook for the month, so they can see at a glance when something
has already been paid.

The partners also can see how much is in the bank now, how much after checks released clear and how much is
needed to cover checks on hold and projections for the entire month.

The Cash Flows Statement in Quickbooks is useful if your cash at the bottom doesn't match your
balance sheet cash, so you can see there is something in the wrong place. But the concept itself
is confusing to the layman.

Hope this helps.

BTW, if you are local or can send me docs online, and need accounting services, I turn raw data into reliable, auditable GAAP financial statements and provide analysis of all sorts for sole proprietors, households, partnerships (LLC's) and small corps.
I can design and set up a system, with a meaningful chart of accounts that offers the kind of data for decision-making
and budgeting. Full charge. Not a CPA, but more than enough accounting credits and over 20 years as an independent contractor with a business license in the city. I have CPA connections for tax purposes. The good news, my rates
have not (yet) changed since 1995 at $50 per hour, plus travel time if you are outside of the city (San Francisco).

I love working with family LLC's and my current clients include commercial real estate, retail, social media, and chinese senior citizen home. Pop me an email if you are interested.
Printer Friendly | Permalink | Reply | Top
 
DU AdBot (1000+ posts) Click to send private message to this author Click to view 
this author's profile Click to add 
this author to your buddy list Click to add 
this author to your Ignore list Wed Sep 17th 2014, 07:04 AM
Response to Original message
Advertisements [?]
 Top

Home » Discuss » DU Groups » Economy & Jobs » Small Business Owners & Entrepreneurs Group Donate to DU

Powered by DCForum+ Version 1.1 Copyright 1997-2002 DCScripts.com
Software has been extensively modified by the DU administrators


Important Notices: By participating on this discussion board, visitors agree to abide by the rules outlined on our Rules page. Messages posted on the Democratic Underground Discussion Forums are the opinions of the individuals who post them, and do not necessarily represent the opinions of Democratic Underground, LLC.

Home  |  Discussion Forums  |  Journals |  Store  |  Donate

About DU  |  Contact Us  |  Privacy Policy

Got a message for Democratic Underground? Click here to send us a message.

© 2001 - 2011 Democratic Underground, LLC