Russell Bowyer
Forum Replies Created
-
Posts
-
Hi Shourob – I am really sorry this has happened – I have fixed the problem and you are now added to the course, so you should be able to login.
Thank you for your purchase, Russell
Hi Dean,
To understand your problem, the best option is for you to send me your cash flow please, as I don’t quite know what the problem is you’re describing. It may be clearer when I see your forecast and the entries you’ve made.
Send it to [email protected], and I will take a look for you.
Russell
Hi Dean, really sorry for not seeing this question.
The difference on the opening tab will be that what you’ve entered does not balance. In other words, what you need to enter is from a balance sheet or a Trial Balance.
How did you enter the information, where did this come from?
Regards, Russell
Hi Dean,
If the tax for last year 2022 has been paid, you can ignore this, but if it’s due for payment in your cash flow period, include this in your opening balances on the “Open” tab.
But the tax cell won’t appear until your switch-on tax on the “Info” tab under Calculate Tax – change this to yes.
Enter your 2022 tax in the brought forward cell on the open, and make sure you input the month the opening tax is paid on the “Info Tab” Where is says “Opening balance tax – ‘Month paid’.
For the tax going forward, by switching the tax to “on” on the “info” tab, the software will automatically calculate the tax on the profits in the profit and loss report based on the tax rate you enter on there “Info” tab for the relevant year.
You also, have additions or deductions to the profits, as taxable profit is not always the same as actual profit.
I hope that helps.
Regards, Russell
Hi Dean,
The cash forecaster has been set so it is all in whole numbers and no decimal points, otherwise you end up with differences in the balance sheet.
Use the =round(£xx x £xx,0) type formula when you do calculations and this should then work.
Hi Dean,
That is a good question, and I’ve not necessarily set the cash forecaster to deal with loans given, but this only becomes a problem if you are going to charge interest on the loan. If you don’t intend to charge interest by Company A to Company B, then enter this under “Other Debtors” on the “Data” tab in the month the money is lent.
To enter loan repayments, simply enter the amount as a negative on the same row as the original loan in the months the repayments are made.
In Company B this is easier, as you can enter the loan on the “Data” tab under “Loans and hire purchase” Enter the loan in the month in which the loan was received. You can change the headings for each loan on the “Info” tab under Loans and hire purchase. This setup will deal with interest charged, term of loan etc.
However, if you prefer, and if no interest is charged, and to keep things simple, use the “Other creditors” section on the “Data” tab in the same way described above for Company A.
Hello Steve,
I can now see what has happened. If you go to the “Data” tab and scroll to B547, which is the fixed asset additions section. This is defaulted to Freehold Property.
Please will you change all of the entries under heading “Choose Fixed assets type” (i.e. from B547 to B586) to either your new Freehold Property heading, or to one of the other fixed asset types where there are no entries for additions.
Of course where there is a fixed asset addition for the asset type, the heading under “Choose Fixed assets type” should be the asset type for the fixed asset addition you’ve already entered.
I hope that makes sense.
I will have to get my thinking hat on to see how I change how this works if one of the headings is changed, but for now this is the easiest and quickest work arounds.
Thank you, Russell
Hello Steve, thank you for your support question.
I have changed the text on my version and I get an error on the Loans and hire purchase line on the balance sheet, is that the same as you get?
Please leave this with me and whilst I look into why this error is happening, please revert the text back to “Freehold Property” in B126.
Thank you, Russell
Hello Alex, thank you for the purchase. I’m afraid you can’t add lines otherwise this would mess up the reports.
You could add the beer duty as an extra cost of sale line, does that help.
Hi Chris,
Firstly, thank you for your five star rating and lovely review and comments – very much appreciated!!
In answer to your question, which I think is you have brought forward losses to set against the first year’s forecast profits. If I am right, the software doesn’t allow for this you are right and this is another great addition. I will incorporate this into the next version and let you know when I’ve done this. It may be a bit late for you for these forecasts unfortunately, but thank you for the suggestion.
However, I think it would work by putting your brought forward loss in cell D59, as this would reduce any profits you have. If the loss brought forward is more than the profit in that year, limit the loss to those profits. Then put the balance of your loss in cell D60, and so on.
I hope that makes sense, but if I’ve missed the point and answered the ‘wrong’ question’ please let me know.
Thank you once again for the lovely words.
Stay safe.
Regards, Russell
Hi Chris,
Firstly, thank you for the lovely comment about Cash Forecaster.
With regards to your question – the software only allows you to enter the opening trial balance on the ‘Open’ tab, but not your full years profit and loss figures I am afraid to say.
This is actually a good idea and I may see if I can incorporate this in the next update, so users can add comparative figures for the prior year.
Thank you.
Russell.
P.s. I would appreciate some positive feedback and a review if you’d be so kind, as this helps others thinking about buying the software, thank you. To add a review is here: http://www.bowraven.com/product/cash-forecaster-software/#reviews
Hello Brian, I forgot to add this to update you – I have sent you the software as an email attachment to your registered email address. Please confirm safe receipt and once again, I’m sorry for this problem.
Russell
Hello Brian, thank you for your message, I will get this sorted for you right away. Sorry this has happened.
Hi Andy, I have just replied to your contact message on this point too. Let me know in reply to my email exactly what it is you are looking for. Let me have a budget of what you had in mind, how much you wan to pay and what you need help with, as I may be able to help you on this myself.
Let me know in an email and I will see if I can help.
Cheers, Russell
Hi Andy, The sum function is only disabled on the main pages to avoid messing up the formulas in the program. What you can do is to add an extra sheet with your workings and calculations as an appendix, which is what many clients do. You can then feed these numbers into the main sheets.
I hope this answers your question, but I noticed you’d also asked a question on the contact form, which I’ve also sent you an email for.
Cheer,s Russell
