Vendor activity not reconciling

Benjamin Gair

Credit card vendor, we do not use the credit card function yet.

I've tick and tied the activity since the inception of the cards (luckily it was only a year in) from the the credit card statements to the vendor activity in the system which I exported to excel and know all records are showing as FE states there are 394 records and my excel file uses 395 rows (one row is the title row). I've identified all the need expenses and credit memos that have been missed, however, FE shows my payment dues is $57.76 short.

Has anyone run into this before? Is there possible activity affecting affecting the balance that does not show under the vendor activity? Maybe something is unposted that I am not seeing? I am very new to FE software so it could be something stupid that I just have no clue about so please don't hesitate even if you think, “My solution is obvious so I am sure they considered it”.

I ultimately will just book an unknown difference given the immateriality if needed but my bigger concern is that we are missing something important that needs done if FE.

Thanks

Benjamin Gair

@Benjamin Gair
figured it out, they made payments in the system that did not actually match the true payments made, smh