Anyone got a useful small business day to day spreadsheet?

[glasgowrob]

As above does anyone have a decent template for a useable and simple way of tracking day to day income and expenditure?


Just thought I'd ask before I spend hours trawling the web

[KingKongIV]

Spreadsheets get messy and annoying. Look into Xero.

[Super Slo Mo]

I used to have some, but migrated over to Sage at my accountant's request.

These days I just tend to knock one up when I need it, they're not that difficult to put together.

I could try and dig out one of our old ones if you want, probably won't be until Monday though.

[trickywoo]

Depends how many transactions you are dealing with but excel is fine for low volume.

[Eric Mc]

And it depends on what controls you want in place - such as how well you want to monitor trade debtors and trade creditors.

[ModernAndy]

excel spreadsheet is fine for a small business without too many inputs. I have one that goes along the lines of:

BALANCE

INCOMES

EXPENSES

VAT

ROLLING INCOME FIGURES

mine has a few different lines that are particularly relevant to how we run the business such as a line specifically for the daily postage cost (this is invoiced every 30 days so isn't used as an expense on the sheet- the invoice we receive from Royal Mail is) which gives us a rough idea of how much the bills are going to be next month.

In the column of the last day of the month I put a few formulas in to work out:

IN FOR MONTH
OUT FOR MONTH
[DIFFERENCE]

DAYS OVER £XXXX
DAYS UNDER £XXXX
AVERAGE INCOME PER DAY

NUMBER OF DAYS
PREDICTED INCOME FOR MONTH (these 2 rows give an indication (not necessarily a particularly reliable one depending on your industry) of how much you'll take in the month- number of days multiplied by average per day)

It works very well as a cashflow control tool and we really don't need anything fancier right now.

[dumfriesdave]

Is it just a simple Cash in/out spreadsheet type thing you are after Rob?

I have a couple a used for my private hire books I can send if they are any use to you.

Send me a message with your email address if needed.