cancel
Showing results for 
Search instead for 
Did you mean: 
neyerbj
Level 3

Reconciliation problme

I did a refinance on an investment property. I was able to get a new loan on an increase appreciation of the asset and swept the excess funds into my business checking for additional purchases. I debited the accounts payable account for the old loan, the interest for that loan for the month, expenses (appraisal, title work, title insurance, etc.) and debited the excess funds into the checking account. I did a single credit into the accounts payable loan account for the new mortgage. All transactions were done in the General Journal as instructed by my accountant.

 

The new loan and transaction occurred after my checking account statement date, but before I received the account statement. QB should handle the funds as funds in transit, but doesn't. It shows up as GENJRNL and not DEP, indicating it isn't treating it as a deposit, but it shows the funds are there. QB won't let me reconcile the account as it shows the funds as a discrepancy. 

 

How do I modify either my General Journal entry or change the entry to a deposit so I can reconcile my checking?

 

I was able to online chat with someone from QB, but they were absolutely no help and only gave me links to Help questions I already read prior to contacting them. I emailed my accountant, but he won't get that until he's back in the office later in the week, but I need to resolve this now, so I can pay some bills.

 

Please help.

 

3 Comments 3
john-pero
Community Champion

Reconciliation problme

As long as your debit for excess funds went directly (in QB) to the proper checking account, it is there. Look at the register view for the account - it may already have been marked reconciled, or more likely, the date of the GJE is after the statement date and you have hidden it from view.  This can happen simply as a data entry error in the date line. 

 

 

neyerbj
Level 3

Reconciliation problme

No, that's not the problem. I guess I'm not explaining it well.

 

The refi was entered properly in the General Journal. Everything balanced. QB showed the funds in the checking account. The problem occurs when I am trying to reconcile the checking account. QB doesn't treat those particular funds as a deposit and handle them as funds in transit.

 

On the reconciliation window it shows the funds on deposit, but gives them a label of GENJRNL compared to a normal deposit it labels DEP. 

 

After I select all the checks and deposits that have cleared and everything is technically in balance, when I try to click the reconcile button QB stops me with a warning that there is a discrepancy that exactly correlates to the funds recorded during the General Journal entry. 

 

I probably am going to anger a few people, but I used to use Peachtree until this year, but they stopped supporting it and it didn't work well under Windows 10. I had to migrate to QB. I did this very same kind of transaction several time without issue in Peachtree. I don't understand the hang-up in QB. 

 

At my accountant's suggestion I deleted the General Journal entry and was able to reconcile my checking, however none of the refi has been accounted for in the books. 

 

Now I postulated a resolution to my accountant, but haven't heard back. What if I now entered the refi transaction again. When the next bank statement comes out I can then check the transaction as having cleared and I should be able to reconcile my checking. What do you think?

 

During this whole process I spent hours texting QB help to resolve the issue. All they did was refer me to help threads I had already read prior to contacting them. To be truthful, I get far better help from this community than from QB directly. It attests to the hard won knowledge from direct use of the product and I thank everyone here. I hope you all can help resolve the problem.

neyerbj
Level 3

Reconciliation problme

I just typed a whole response and the board are it. Ugg!

 

I'm not explaining it well I guess.

 

I entered the refi numbers correctly, they all balanced. QB showed the excess funds in my checking account. The problem comes when I try to reconcile my checking account.

 

In the reconciliation window it shows the funds there, but gives them the label of GENJRNL as compared to a regular deposit label of DEP. 

 

After I check all deposits and checks that have cleared and click the Reconcile button QB pops up a warning that there is a discrepancy equal to those funds. Clearly QB is not treating those funds entered via the journal as a normal deposit, but QB should be treating them as funds in transit.

 

My accountant told me to delete the refi transaction entered in the journal and only then was I able to reconcile my checking account. The problem being those funds are in my account, just not entered on my books and I need to have that done.

Need to get in touch?

Contact us