Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi there, @sfliquidationtru. I'll share with you the steps on how to upload and print batch checks in QuickBooks Online (QBO).
In QBO, you can print bulk checks by checking the Print Later box when recording your transactions. After that, reopen your check to proceed with the printing process.
To learn more about printing checks in QBO, you can check out this article: Print a check in QuickBooks Online. And, here's how you can print batch checks in QuickBooks Desktop (QBDT): Print checks one at a time or in a batch.
On the other hand, you can use an Excel CSV file in 3-column or 4-column format to upload your check entries to QuickBooks. To know more about the process, you can open this link: Manually upload transactions into QuickBooks Online.
Once done, you're now ready to categorize the entries to put them in the correct accounts.
Let me know if you have any other follow-up questions about uploading or printing your check transactions. I'm more than happy to provide additional assistance.
Prepare the Checks data with the following template
RefNumber | BankAccount | Vendor | PrintOnCheckName | TxnDate | Location | AddressLine1 | AddressLine2 | AddressLine3 | AddressLine4 | AddressCity | AddressState | AddressPostalCode | AddressCountry | PrivateNote | ToBePrinted | Currency | ExchangeRate | ExpenseAccount | ExpenseDesc | ExpenseAmount | ExpenseBillableStatus | ExpenseBillableEntity | ExpenseClass | LineItem | LineDesc | LineQty | LineUnitPrice | LineAmount | LineBillableStatus | LineBillableEntity | LineClass |
101 | Checking | Joe's Coffee | ######### | 12 Main Street | Suite 102 | Albany | NY | 12345 | N | General Supplies | General Supplies | 85.21 | |||||||||||||||||||
102 | Checking | Costco | ######### | PO Box 1000 | Dallas | TX | 28456 | N | General Supplies | General Supplies | 125 | ||||||||||||||||||||
103 | Checking | Property Mgmt Assoc | ######### | PO Box 1800 | Albany | NY | 12345 | Mar 2011 Rent | N | Rent | Rent | 1000 | |||||||||||||||||||
103 | Checking | Property Mgmt Assoc | ######### | PO Box 1800 | Albany | NY | 12345 | Mar 2011 Rent | N | Common Area Maintenance | Common Area Maintenance | 100 |
then utilize an importer tool
https://transactionpro.grsm.io/qbo
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