Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowHi! I have a client that owns a restaurant and still hand writes all of their check payments to vendors. I am linked to their bank, however it's a small credit union that combines their main account and payroll account together on the statements. The checks written do not show the vendor and the majority of electronic payments do not match up to QuickBooks vendors. Currently, I download the bank statement, convert it to excel, go into the bank and view the checks one-by-one, then manually enter all of the vendor names after looking each one up. I have a formula that matches the vendor name and enters the QB account into the spreadsheet. Lastly, I do a bulk transaction upload. This takes a very long time. Does anyone have a suggestion of a more efficient way to do this? Is there a third party app or anyway for the client to send a picture of the check and QB will upload and record it? I appreciate any suggestions! Thanks!
I appreciate your diligence in recording transactions in QuickBooks Desktop (QBDT), @Pward1011. I recognize that manual data entry can be time-consuming. For more efficiency, you can directly upload transactions into the system. Allow me to guide you through this procedure to help you save time.
To expedite uploading transactions in QBDT, consider downloading your bank transactions and preparing them to use an IIF rather than a CSV file. This approach allows for more efficiency in exporting, importing, and editing IIF files directly in QuickBooks than manual entry.
Here's how to import your IIF files:
If you're looking for a third-party app compatible with QuickBooks Desktop (QBDT), you can search on Google for options. QBDT also has a mobile app that lets you upload checks by taking a photo for automatic processing. If you use QuickBooks Desktop Plus, Accountant, or Enterprise, your receipt information will be matched with existing transactions for your review and approval.
Refer to this resource for step-by-step instructions in uploading your receipts in QBDT: Upload receipts to QuickBooks Desktop Plus, Accountant, or Enterprise.
Additionally, to further automate your process, consider setting up rules to categorize transactions for frequent expenses such as supplies or other business costs. Here is an article that guides you through creating rules in QBDT: Create rules to categorize transactions in QuickBooks Desktop.
If you require additional assistance recording bulk transactions or have any other questions, please don't hesitate to contact us. We're here to support you in your accounting experience to be as smooth and efficient as possible.
Thank you, that was very helpful!
We're thrilled that @EvethC's advice proved useful in resolving your issues, @Pward1011. The Community takes great satisfaction in offering support and helping to optimize your business operations.
If you find yourself facing any additional questions or needing help with uploading checks, please feel free to return to this conversation. Remember, our Community stands ready to assist you at any time, so don't hesitate to reach out when you need us.
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.
For more information visit our Security Center or to report suspicious websites you can contact us here