Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Prepare the Credit Card Charges with the following template
RefNumber | CreditCard | Payee | TxnDate | Location | AddressLine1 | AddressLine2 | AddressLine3 | AddressLine4 | AddressCity | AddressState | AddressPostalCode | AddressCountry | PrivateNote | Currency | ExchangeRate | ExpenseAccount | ExpenseDesc | ExpenseAmount | ExpenseBillableStatus | ExpenseBillableEntity | ExpenseClass | LineItem | LineDesc | LineQty | LineUnitPrice | LineAmount | LineBillableStatus | LineBillableEntity | LineClass |
101 | Visa Account | Starbucks | 01/10/2020 | General Supplies | Miscellaneous | 12.51 | Supplies | 1 | 12 | ||||||||||||||||||||
102 | Amex | Costco | 01/10/2020 | General Supplies | Office Supplies | 125 | |||||||||||||||||||||||
103 | MasterCard | Staples, Inc. | 01/10/2020 | Office Supplies | Office Supplies | 25 |
then utilize an importer tool
https://transactionpro.grsm.io/qbo
Hi ernesto-correa-m,
It's great to hear from you again. Manually uploading transactions is one of the great options available for simplifying your data entry, and I can appreciate wanting to make sure your file is formatted correctly before diving in. I can show you some resources that can help with formatting your CSV to manually upload your transactions in QuickBooks Online.
Apart from third-party apps like Fiat Lux mentions, you can also use the built-in import features to manually upload your credit card transactions. It sounds to me like that's what you're looking to do, and you'd just like to first confirm the formatting for the file. I've got an article here that breaks it down so you can get started: Format CSV files in Excel to get bank transactions into QuickBooks
Once you've got the file formatted, you can use the steps in the article Manually upload transactions into QuickBooks Online to upload the information. You can use these steps even if you've created your own file rather than getting one from the bank. If you'd like a full overview of the import options for QuickBooks Online, check out this article: Common questions about importing data to QuickBooks Online
You're also welcome to explore third-party app options if you'd prefer. The Apps tab in your account is useful for researching available options, seeing information about them, and even reviews from other customers to make sure you've got a good fit.
Feel free to ask more questions if you have them!
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