Have a Finance Question? Ask a Financial Expert Online.
Thanks, XXXXX XXXXX requesting me.
You can send the file using the paperclip icon. Please remove all identifying information as this is posted on the web
Thank you. Just one second while I remove identifying info.
It looks good. Looks like you have a mess on your hands, though lol
Do you need anything else today, Terry?
Well, I lost connection with the chat for a few minutes there. Were you able to view the file I sent?
Yes I was
And I said that it looked good...but looked like you had a mess on your hands!
I don't see that in the chat window. I have a few questions to clarify what I am doing, if you don't mind.
That's no problem at all
Balance per Books: January receipts - I took that from the total of debits in the G/L cash account for January, but I'm thinking it should have come from the cash receipts report?
There should be a cash receipts report...but if they aren't keeping their books up, then it may not be accurate
It may not be accurate, but that should be where I pull that number from, not the total of the debits in the G/L account, correct?
That's right, because there may be other debits in there like interest revenue etc
The corrected balance per books for Jan. receipts agrees with the cash receipts report, after I subtract the errors and adjustments. But that was starting with the total debits like I said. So if I start with the cash receipts report then I would not show those adjustments in column 2, correct/
That is correct
Apply the same scenario to the Jan disbursements. On the worksheet you have, I started with the total of all credits in the G/L cash account. I'm thinking that was not correct. I should take the starting number from the cash disbursements report or something similar?
That would be correct...
Because credits could include NSF checks, bank fees, etc
Thank you. Now about the errors and adjustments in the cash account that are not actually cash receipts nor disbursements, where do I put them on the proof of cash?
You can make a separate column for that
Thank you, XXXXX XXXXX make those corrections and try again. My head is hurting, but I am determined to get this thing straightened out.
LOL I know the feeling.
Would it be okay to contact you for follow up
I'm working on a few of my own
Yes, you can just ask for me again if you need to follow up
Megan, I have adjusted my initial worksheet to reflect "Book" receipts compiled from the cash summary report (A/R module) and any JE's. The "Book" disbursements comes from the check register and JE's (mainly payroll ACH). From plugging in these updated numbers, it appears that for the month of January, at least, cash receipts and cash disbursements were properly recorded. I do have some small adjustments to make of erroneous entries to cash. The difference between bank and book corrected balance remains the same. What should I do with this difference? I was thinking about making a journal entry to debit cash $51,505.21 and credit misc expense to the Jan. time period, but that would make any old reports between then and now meaningless. I am attaching a new worksheet.
Thank you for your help. I very much appreciate your expertise and having someone to go to when I am stumped.