I use Sage 50 Accounts to look after my business' books. up until now things have worked out nicely. The problem comes in when I have to create an excel spreadsheet manually for the actuals/forecast. It seems (due to human error) I cannot get the spreadsheet to marry up with my bank balances. After running through all my bank statements and redoing the spreadsheet manually it still fails to balance:(.
So being a newbie to accounts etc. is there a process I should be following to make life easier. Maybe a more automated way of exporting from Sage to excel? I have attached the cash flow projection spreadsheet I use for actuals & forecast. Do I need some additional software from Sage or some other company to achieve the automation?
Any ideas would be appreciated and thanks for reading.
I could be being dumb here but why is the total cash paid out your cash paid out subtotal (overheads) minus what looks to be exceptional payments (C46 to C50). Shouldn't it be plus?