Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowHelp 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?
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.
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
Hi JessT,
I will try this fix this weekend and see if it says there was corrupt data. Thank you.
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.
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
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.