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 nowHello there, @adavis2.
Let me share some information on how you can manage your downloaded expense transactions.
To start with, the data downloaded in your QuickBooks account depends on the information Certify shares with us. Modifying it is currently not available. However, you need not worry, you can download your transactions from Certify and import it to QuickBooks. Just make sure that the it follows the required format.
Once completed, you can start importing your transactions. Now, you can manually review each employee expense and assign the appropriate category.
Also, I've added these articles to help you manage your downloaded bank transactions:
Know that the Community and I are always here to help if you have other questions about managing your transactions.
If you don't mind to work manually, you may prepare the JE data in XLS and utilize an importer tool
https:// transactionpro.grsm.io/qbo
The template should be like this
RefNumber | TxnDate | PrivateNote | IsAdjustment | Currency | ExchangeRate | Account | LineAmount | LineDesc | Entity | Class | Location |
101 | 01/10/2020 | Wire Transfer | FALSE | Savings | -50,00 | Credit Savings | |||||
101 | 01/10/2020 | Wire Transfer | FALSE | Checking | 50,00 | Debit Checking | |||||
102 | 01/10/2020 | Wire Transfer | FALSE | Savings | 200,00 | Debit Savings | |||||
102 | 01/10/2020 | Wire Transfer | FALSE | Checking | -200,00 | Credit Checking |
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.