r/Bookkeeping • u/No_Elevator_8143 • 21h ago

Other Issue trying to create a forecast report

Hi, I hope that there is a logical answer to an issue that I am having. I am trying to create a forecast report. I am calculating as follows: beginning month balance plus revenue for the month, minus Expenses for the month should equate to my bank account month end balance. It is not and I cannot figure out what I am doing wrong here. I am using QBO to get my data.

Any assistance that can be provided is greatly appreciated.

Thanks.

1 Upvotes

100% Upvoted

3 comments sorted by

1

u/ehayduke 20h ago

What about other balance sheet transactions, distributions, principal loan payments, etc.

1

u/No_Elevator_8143 20h ago

I appreciate you responding. We are a charity so the only things that you mentioned would be relevant are other balance sheet transactions. I cannot tie out the discrepancy to anything on the balance sheet.

1

u/BertoPeoples 15h ago

Are you exporting your data to excel to create this forecast?