Hello Everyone,
We have succesfuly done the RMS to QB Integration, but there is a small problem after we post the batches to QB, the GL Journal Entries are not in Numerical Account Order. The Accountant that we are dealing with is very picky and is complaining that it very stupid the way that RMS post the batch to QB. i.e. Memo Account Debits Credits RMS COGS... 5000 - Cost of Good.. 517.43 RMS Tender... 1100 - Bank of Amer.. 669.72 RMS Tender... 6100 - Credit Slips...
13.00 RMS Tender... 1240 - Charges - Credit C 461.00 RMS Tender... 6100 - Credit Slips... 57.22 RMS COGS... 1300 - Inventory Asset
517.43 RMS Sales... 4100 - Sales Taxables
1,124.18 RMS Tender... 4095 - Overages
10.53 RMS Tax Col... 2700 - State Tax
66.79
The way that the accountant would like to see the Batch posted is like this:
Memo Account Debits Credits RMS Tender... 1100 - Bank of Amer.. 669.72 RMS Tender... 1240 - Charges - Credit C 461.00 RMS COGS... 5000 - Cost of Good.. 517.43 RMS Tender... 6100 - Credit Slips...
13.00 RMS Tender... 6100 - Credit Slips... 57.22 RMS COGS... 1300 - Inventory Asset
517.43 RMS Tax Col... 2700 - State Tax
66.79 RMS Tender... 4095 - Overages
10.53 RMS Sales... 4100 - Sales Taxables
1,124.18
The problem in the way that RMS posts the batch is that in the QB Check Register, for the Bank of America Account, The deposit amount is Correct $669.72 but the account that shows is the COGS account 5000.
Please help
Rommel J. Jimenez