RMS and Quickbooks

I am a Canadian user of Microsoft RMS. I have never used Quickbooks before (all accounting was prevoiusly done by hand), but want to get started.

I only use RMS (Store Operations) for recording sales at my store. I don't use the Purchase Order Functionality provided by RMS. With regards to Quickbooks, the only thing that I really need to do is post the batch tender information from RMS into quickbooks.

Currently, I have a single reigster system using RMS. Although i run the Z-report at the end of every day, I do not bother with entering opening or closing amounts. I'm guessing That means I problably have consisent Short-Tender issues every day.

Is this going to be a problem when importing data into quickbooks? Is there a way to simply post all the tender info (cash, credit, etc) into Quickbooks, without worrying about the closing amounts at the register balancing out? If i need perfect balances, how can I do that for previous batch data (say from 2 months ago)?

I don't know if I am asking the right questions at this point, but any help will be greatly appreciated.

Thanks.

Reply to
SambaNoodles
Loading thread data ...

I had the same situation as you (I don't enter opering or closing amounts and only needed to enter tender and sales information) and got this to work by rigging the system. Here is the simple answer: When you set up the "Assign GL account" make sure to assign QB codes under the debit column for "Tender Shorts" and assign QB codes on the credit column for "Sales".

Once you get this all setup you can post batches for as long as you've been using RMS.

Chris

Reply to
Bopper

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.