Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello there.
I'll be sure to help you get your petty cash transactions to QuickBooks Online (QBO).
Yes. You can upload petty cash tractions to QuickBooks. Make sure you meet the requirements and follow the format successfully. See this article for details: Common questions about importing data to QuickBooks Online.
In QBO, you can import your data through the Gear icon and click Import Data. Otherwise, you can follow the steps below to import your bank transactions to your company file.
Once you get your transactions to QuickBooks, you'll want to match and categorise them. The transactions go into your accounts after you review them.
I'm also attaching this article for future reference in reconciling your accounts so they always match your bank and credit card statements: Reconcile an account in QuickBooks Online.
Tag me in the comment below if you have clarification on managing petty cash and other transactions in QuickBooks. I'll always be around to help you.
Prepare your Purchase Cash 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 | Location |
101 | Cash On Hand | Joe's Coffee | 01/10/2020 | 12 Main Street | Suite 102 | Albany | NY | 12345 | N | General Supplies | General Supplies | 85.21 | ||||||||||||||||||||
102 | Cash On Hand | Costco | 01/10/2020 | PO Box 1000 | Dallas | TX | 28456 | N | General Supplies | General Supplies | 125 | |||||||||||||||||||||
103 | Cash On Hand | Property Mgmt Assoc | 01/10/2020 | PO Box 1800 | Albany | NY | 12345 | Mar 2011 Rent | N | Rent | Rent | 1000 |
then use an importer tool to proceed
https://get.transactionpro.com/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