cancel
Showing results for 
Search instead for 
Did you mean: 
Flummoxed 77
Level 1

Reconciling is a nightmare now

Help some one, I must be doing something wrong now.  I am on QB Desktop Pro 2018.  I used to pay all my business bills through their online banking, then download and reconcile each month.  Now, they don't do online bank checks anymore, so I use my own banks online payments and then download each month, but the entering of the downloaded transactions takes forever.  And I only have about 25 or so, but it matching up the invoices to the checks to match the amount.  And then I am finding QB is not marking the invoices paid, so I have to go in and change the expense account  to accounts payable, close that then open pay bills and pick the invoices to match the check, click on credits that has been created from the check and use that to get the check to be a bill payment.  I hope that makes sense!  It took me 2 hours to reconcile April instead of maybe 20 minutes like it used to be. So, am I doing something wrong or...help?

5 Comments 5
JessT
Moderator

Reconciling is a nightmare now

Hi Flummoxed 77,

 

I can imagine the things you've been through to reconcile your account.

 

You're doing the right thing, and your workaround is also correct. The challenge here is the long process because of the workaround. The root cause is the vendor invoices remain unpaid after you matched them with the bank feeds, which shouldn't be. This is what we need to solve, and I'll help you out.

 

We'll run the verify and rebuild data utilities to check the integrity of your company file. These tools diagnose and resolve data damage that causes incorrect statuses on the transactions and reports. You can find the detailed steps in this article: Fix data damage on your QuickBooks Desktop company file.

 

Feel free to update us when you match your transactions in the future. We're just right here to lend you a hand.

john-pero
Community Champion

Reconciling is a nightmare now

With only 25 transactions I suggest you go old school and enter  them as they happen and skip downloading anything other than the monthly e-statement from the bank to use reconciling. With that few, reconciling should take mere minutes.  It is all about performing the processes yourself up front rather than when you reconcile

Flummoxed 77
Level 1

Reconciling is a nightmare now

Hi JessT,

 

I will try this fix this weekend and see if it says there was corrupt data.  Thank you.

Flummoxed 77
Level 1

Reconciling is a nightmare now

Hi John,

thanks for your suggestions, but I don't think I understand. I enter the vendors' bills as I get them, but when I pay the vendors, I go to my online bank, as QB doesn't pay online anymore thru Desktop.  So, now I have paid the invoices, but if I mark them paid in QB , then when I download the month to reconcile the transactions, there is no match to the downloaded transactions. If you see what I mean.   Once QB did away with the banking part of the Desktop program, it is almost more trouble than it is worth.  I need those end of the year statements for our business, but it has definitely become more fiddly.  If you could explain a little bit more what you mean, I would appreciate it. Thanks.

btks
Level 5

Reconciling is a nightmare now

When you pay bills:

- choose "pay bills" on the home page or vendors menu

- select the invoices that you are paying ( there are several sorting options at the top)

- when you have the invoices checkmarked, go the bottom and choose "assign check number" and the bank account you are paying from

- click the "pay selected bills" button

- choose "let me assign the check numbers below" and then enter ACH or whatever you want, or no #

- Hit ok

-this will put an entry of the total $ amount of invoices paid, per vendor, in the check register for reconciling as usual.  It will also mark the invoices as paid.

-then just pay your bills through your bank

Need to get in touch?

Contact us