I have wracked my brain and body trying to find where my accounts don't line up between RMS and Quickbooks. I had not been able to Post journals from April 1 till last night, and I close a batch every 3 or 4 days, so I had a bunch. I figured out last night that I had forgotten to add Debits into my quickbook accounts, and once that was remedied, I was able to post about 80% of the journals.
Now, I have 7 left, and I have compared all my Z reports between the ones that did post and the ones that did not post, and I can't find anything that doesn't match. Anybody have another way to figure out what doesn't balance????
It's not that they don't line up between RMS & Quickbooks, it's that they don't line up between Credits & Debits...
There is (or at least was) a Knowledge base article in Customer Source that details the most common credit/debit settings for mapping accounts. Some of the mappable values need to be mapped to both a debit account AND a credit account for the posting to balance.
Some likely reasons that older batches may not post: You have deleted departments, items or tender types since the batch closed You have moved an item from one department to another (not sure about this one, but I seem to remember finding a scenario where this would be a problem).
It's probably just that your account mapping is still not quite right...
If you can't find the error any other way, you can switch the account export type to "RMS XML" and post the batches to that. This format doesn't check for in balance - it just posts to a file. You can open that file in notepad and see which values posted to which accounts. Sum the Debits and then subtract one from the other - that will tell you the amount that is out of balance, and you can usually find a matchingvalue in the z-report or by scanning the journal for that batch...
Glenn Adams Tiber Creek C> I have wracked my brain and body trying to find where my accounts don't line
thanks for the detailed reply. I am going to see what I can do now that I'm back in the saddle this morning. I haven't been able to pull up that article you referenced for the mapping info. If you know the link or have the article copied somewhere, could you forward it? thanks, and I will let you know if I succeed.
Another problem can be items with no dept. code association. (unless you don't use depts.) This has caused problems for me when new items are added incorrectly.
If you can open the export file in exel it's easier to see where the imbalance is. I have to do this with my xml files. (GP) Make sure you do this with a copy and keep the original, Excel can reformat it to something unreadable to QB.
I have another question that my bookkeeper has not been able to answer. If you manually post a journal entry, how the heck do you get that journal off the closed batches list so that you don't have to uncheck it every time you go to post journals. the previous owners here had four from 2005 that never posted - needless to say I don't need them at all, but can't figure out how to eliminate them.
again, change the accounting type to anything other than Quickbooks
2003. All of the other types just save the batch to a file to later be imported into the accounting system. Post the old batches to a file, then change the accounting type back to qb 2003 - you have need to attach to the QB database again, but I believe it will be saved.
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.