Can't find posted checks...

[gospeltab]

We currently have 3 funds - general, missions, and benevolence. I was a bit behind on the books and was catching up on November and December benevolence transactions. Someone misordered checks so we had several duplicate numbers...two of them got used before I could get rid of them.

On 11/26/13 I entered the first transaction using 1450D (the D for duplicate) and 1451D. Both check numbers showed up on the posting list so I posted everything from accounts payable. I then posted from fund accounting. I am now trying to reconcile the account and neither of these transactions are showing up on the reconciliation page.

I went into vendor accounts and pulled up the vendors and on the vendor history page the transactions show up correctly. I am so puzzled as to why these two transactions are not showing up on my fund accounting view posted transaction pages.

Because they are not showing up my bank balance is off and I can't reconcile the account...

I would really appreciate any help you can give me...thanks so much!

Deanne

[NeilZ]

We currently have 3 funds - general, missions, and benevolence. I was a bit behind on the books and was catching up on November and December benevolence transactions. Someone misordered checks so we had several duplicate numbers...two of them got used before I could get rid of them.

On 11/26/13 I entered the first transaction using 1450D (the D for duplicate) and 1451D. Both check numbers showed up on the posting list so I posted everything from accounts payable. I then posted from fund accounting. I am now trying to reconcile the account and neither of these transactions are showing up on the reconciliation page.

I went into vendor accounts and pulled up the vendors and on the vendor history page the transactions show up correctly. I am so puzzled as to why these two transactions are not showing up on my fund accounting view posted transaction pages.

Because they are not showing up my bank balance is off and I can't reconcile the account...

I would really appreciate any help you can give me...thanks so much!

Deanne

Try selecting "Show ALL Transactions" when the reconciliation screen first appears.

[gospeltab]

I tried posting all the transactions as well...the checks are nowhere to be found...I am so totally perplexed...

[NeilZ]

I tried posting all the transactions as well...the checks are nowhere to be found...I am so totally perplexed...

Have you set the 'SHOW ALL TRANSACTIONS' in the reconciliation?

Another thing to look at, if you have set your current open MONTH to one in 2014, you won't see anything from 2013 in the Posted Transactions list.

[gospeltab]

I also just went into payables and clicked on void check. When I entered the number 1450D the check appeared and gave me the option to void it. I did not at this point, but should I try voiding them and redoing them?

Deanne

[gospeltab]

I currently have the working month set to December 2013

[NeilZ]

I also just went into payables and clicked on void check. When I entered the number 1450D the check appeared and gave me the option to void it. I did not at this point, but should I try voiding them and redoing them?

I currently have the working month set to December 2013

Deanne

The reason you see them in the VOID Check dialog is that they are posted in the Accounts Payable database. The issue here is where are they in the Funds Accounting database.

Since you have the working month as December 2013, you should be able to enter the View Posted Transactions function, and bring up the entire list of transactions. Sort on the first field by clicking on the header, and look for those two checks. If you don't see them AT ALL, take a look at the Vendor record and verify the date they were written. Make sure that the year is 2013, and that there wasn't a 'fat finger' that made it 2014 or 2012.

If you still cannot find them in Funds Accounting, and the amount you're off is exactly the amount of the two checks, somehow they did not get posted to Funds Accounting. You may want to manually add those two transactions in Funds Accounting yourself.