reconciliation problem

[bjsbrown65]

The first month (before Mark suggested using the AP manual check module), I created manual invoices in AP and when I paid the bill, it listed all the invoices on the check which I expected. However, The check after posting to fund accounting appeared in the credit card reconciliation rather than the bank statement reconciliation. I reversed and cleared up the credit card rec as the entries balanced out. Then in order to show the check as clearing the bank, I did another manual check and it posted to the bank recon. The problem is it also posted to the credit card recon. Big surprise. What am I doing wrong and how do I correct this. I have tried everything I know. Thanks.

[JohnDMeyers]

I would need to know the account details.

It sounds like you are entering the 4-digit account number for the Credit Card account as the CR account instead of the 4-digit number for the bank account.

[bjsbrown65]

I did as you suggested in my first post feb 20, 2014. Entered the purchase using the credit card liability and the expense account. For example on a $407 purchase, cr the credit card liability acct and debited the office supplies. Then when I paid the bill, I checked/selected the purchases associated with the invoice to pay under print computer check. Since I didn't print a manual check, I did not have the option to enter the bank account. On the journal report for this transaction, it shows the 407 credit for the credit card acct and debit for the expense acct. I agree with you that this is why it posted to the liability account rather than the checking account. It's just wrong for one this one month. I didn't retain the backups for that time period so restoring isn't an option. Is there a way to straighten it out.
Thanks.

[JohnDMeyers]

I will try to reconstruct what I think you did, and how to remedy my assumption:

I think you initially did this:
CR 01-2010-000 credit card liability $407
DB 01-5678-000 some expense $407

Then, I think you did this:
DB 01-2010-000 credit card liability $407
CR 01-5678-000 some expense $407

If so, you un-did the first thing, so you need to redo it:
CR 01-2010-000 credit card liability $407
DB 01-5678-000 some expense $407

And then do this:
CR 01-110-000 checking $407
DB 01-2010-000 credit card liability $407

[bjsbrown65]

Your assumed first step is correct; however, I did not do the second step and reverse/undo the transaction unless there is a command which would have but the journal report shows it reversing the credits/debits as your second step. After I entered the ap invoice, I simply paid the invoices using print computer check. I'm going to experiment with your suggestion and will let you know results. Thanks.

[bjsbrown65]

John, when I redo the first thing, where i.e. fund acct, manual invoice or manual check.