Step #1 - run your daily transaction register from general ledger | main to make sure something didn't get updated.

Step #2 - Start by looking through the general ledger transactions for the amount in question.
Step #3 - Then look through the purchases clearing report for the same amount.

If you are lucky, it will be one item. Odds are that since you are asking here, it wasn't.

Assuming you reconcile on a regular basis it should it shouldn't be too hard to find the transaction in question in the more recent postings (once again assuming you are lucky).

After that I wouldn't waste a lot of time on that small amount. Not being snarky, just realistic. Spending too much time hunting for that small amount just isn't cost effective. I know, it annoys me too and I like to resolve these things as well. At the beginning of my career 30 some years ago I once spent 8 hours looking for $25. Partner at the CPA firm was a little ticked at me for that one since at my billing rate it probably would have been more than a $500 charge to the client. I don't do that any more.

If it was $5,000, I would have a different opinion.

You might let it ride for a week or two and see if it self corrects. If it doesn't, I would just make a plug journal entry.

Everything worked out in 2015. Now, for some reason, I am out of balance over $2000. Now what?

Start by the original suggestions.

Some more reasons you can be out of sync I have learned since 2015.

1. Make sure that when you run the purchases clearing report for ALL items, not just inventory items. (had a client excluding miscellaneous item).

2. Watch your general ledger for stray postings from unexpected journals. Normally you would expect them to be posted from PO journals (I'm sure there are some others, but at the moment my mind is blank, sorry).

3. I have seen at once where a receipt of invoice did not post correctly to the purchases clearing records but did post correctly to the general ledger (maybe it was the other way round). Client spotted because they were reconciling daily so they didn't have many transactions to look through. Something like that is tough to spot. About the only suggestion I have on something like that is to let it ride and see what older items don't clear out.

Thanks for the additional information. I ticked the box for All Types and now I am off $11,654.04. Why do I need to care about these being in balance? We didn't have this type of thing at my other company. Should I be worried?

Potentially it means that you could have double recorded or underrecorded an expense/inventory item.

Think of it this way. Purchases clearing is really accounts payable for items that have been received into inventory for which you have not yet received the official invoice from the vendor.

It's really the equivalent of your A/P Trial Balance which should agree to your general ledger control account (or your A/R trial balance or your bank reconciliation).

I was a CPA and auditor for about 28 years. As part of that process I would want the client to show me that they had records that supported that number on the general ledger. Countless times I would have someone give me a bank reconciliation/AR trial balance/AP trial balance that showed one amount and a different amount appeared on the general ledger.

I find that a lot of people using Sage 100 don't truly understand purchases clearing.

Follow the attached link to my website for some tips on purchases clearing.

www.target-sys-tech.com/MAS90-tips-purchases-clearing.pdf

This is very helpful information. Thank you so much. I can't promise this is the last time I will have questions on this subject.

No worries. Purchases clearing is one of those things that periodically raises its ugly head because we all make mistakes from time to time. The trick is to establish procedures to minimize the mistakes.

Sometimes I have people change the price of an item after it was received. This to would make this report not balance. If it is received in at one price and then that price is changed, the clearing report uses the cost within the item at the time you print the report. My rule is no one is allowed to change prices if a receipt of goods was done. Good luck..

The PO module should post a variance when the invoiced amount doesn't match the RoG amount.