Tender Paid Out unbalance Amount Deposited in Bank

Hello,

I am trying to integrate RMS with QuickBooks 2006 everything is being good so far, but every time that there is a Paid Out the Bank deposit does not match what the Journal Entry Reflects. i.e

Bank Deposit Slip with a Deposit of $966.44

---------------------------------------------------

Paid Out on Z Report $5.91

QB Bank Account $972.35

If you subtract $972.35 - $5.91 = $966.44

My Accountant/Book keeper is telling me that this cannot be like this that it should be $966.44 he is concerned about when bank reconciliation comes that he would have transactions that the bank never will report, Is this normal? am I doing something wrong?

I have been trying many different combinations and I get the same answer

Rommel Jimenez

Reply to
Rommel J. Jimenez
Loading thread data ...

Do a search on Quckbooks integration. I have a thread about 4 months ago that covers this topic extensively. Basically we quit entering opening amounts and started posting the closing amounts. But read the thread, because there is some good info. Craig

Reply to
Craig

Craig,

Where exactly did you read that?

Reply to
Rommel J. Jimenez

Reply to
Craig

Craig,

Do you happen to have the august Posts in your news reader? I am google it and I get not answers....

Rommel

Reply to
Rommel J. Jimenez

Reply to
Craig

Craig I found it, But I still quite dont get it. Do I have to no to enter the opening amounts? I am going to post the conversation yours and Todd.

From: "Craig" Subject: Re: Could this be a bug? Date: Fri, 15 Sep 2006 23:21:34 -0400

Todd, I want to thank you for your time. I appreciate your efforts. I understand your methods, and that definitly appears to be the answer. In following the instructions on costomersource it never mentioned leaving the opening blank, but put in closing amounts. Even in your computation method it says it will subtract the opening amount and the payout. I will agree to disagree that it works as designed. :) As long as I have a way to make it work I'm happy.

BTW, did you ever figure out why I'm not showing up as a managed account? Craig

Reply to
Rommel J. Jimenez

That's correct. With the method I am using to post to QB, I am not supposed to enter Opening amounts. The Closing Amounts, not Tender Received, are what I post to QB as my deposit. Tender Received doesn't get mapped at all. This method may not work for you, depending on how the rest of your accounts are mapped. Each method seems to have it's own little quirck in what gets mapped and what doesn't. Craig

Reply to
Craig

I have been wondering about how people handle opening/closing amounts. I can't fugure out why the opening amount is really necessary, but I have been entering $200 at the start of the day (for my initial drawer) and entering the closing amount that includes the $200 I leave in the drawer at the end of the night. I guess I could just enter $0 at opening and for closing, just enter the amount I take to deposit.

Any comments?

Reply to
Jason

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.