Spreadsheet

[ceetee]

Tweet

Ok here's a basic question, I've been using a cash flow spreadsheet and it's now over a year in business, do I start a new spreadsheet for the next financial year or keep extending this one?

Both alternatives seem a bit weird. Either it will grow into a monster of a spreadsheet or chop up the financial history.

[zinc]

Per year, do it in a DB or get some software

[Donk]

If you're using Excel create a new sheet (the tabs at the bottom) in the same spreadsheet.

You can then use a third sheet to compare trends etc.

[essdeekay]

I would go with Donk's option.

Si

[hrbs]

Hi

Depends upon how complex/sophisticated your cashflow is. I usually use separate tabs for monthly expenditure and income types and a 1 page summary which uses lookups for the range to display (cashflow is analysed on a weekly basis and surplus funds for transferring to a deposit account can be easily identified).

If it is quite a complex cashflow I would use your existing spreadsheet as the model, save with a new name and paste the closing balances in as opening balances into the new spreadsheet (use paste special/values and number formats).

If it is quite simple, use a new sheet/tab as Donk says, and link the opening balance to the closing balance from the earlier year. You can copy the existing sheet as a new sheet by right clicking on the tab name and creating a copy and renaming.

Regards
Keith
High Royd Business Services Limited
Small Business Specialists

hrbsonline.com - online accounting solutions
** NEW - Accounting and taxation tips at tips.hrbs.biz **
Have a question? Request an article or add your own tip.

[ceetee]

Cheers for all the replies. The cashflow is simple enough to fit on a single page so I've gone with Donk's idea.