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 nowI have a bank checking account that Quickbooks won't connect to and thus there are no downloaded deposits in the bank feed to match and close out paid invoices. I've already wasted enough time on the problem, I'm moving to a new bank so I am not worried about fixing the failed connection. What I need to know is how do I manually create the transactions in the bank feed (as if they were downloaded) so I can then match the deposits and close the invoices?
I can help enter your transactions, Race-MX.
To add bank transactions in QuickBooks Online (QBO), you can create a CSV file using either a 3-column or 4-column format. If you choose the 3-column, the deposit should have a positive number, while the expenses and charges should be represented as negative numbers or with a minus sign. On the other hand, if you prefer to use the 4-column format, it should include debits and credits for each transaction.
For more information, check this link: Format CSV in Excel to get bank transactions into QuickBooks.
After that, you can manually upload it to the program. Here's how:
Check this guide for more details: Manually upload transactions.
You might find the following articles helpful about adding and matching transactions in QBO:
Keep me posted if you have any other questions about connecting your bank to QuickBooks. I'm always here to help. Take care.
You can prepare Receive Payment data with the following template
RefNumber | TxnDate | PaymentRefNumber | Customer | PaymentMethod | DepositToAccount | InvoiceApplyTo | LineAmount | PrivateNote | Currency | ExchangeRate |
1 | 28/11/2020 | 50245 | Janice Johnson | Check | Checking | 101 | 100.00 | |||
2 | 28/11/2020 | 4908 | Leonard Walker Inc | Check | Checking | 102 | 138.78 | |||
3 | 28/11/2020 | 4908 | Lisa Smith | Check | Checking | 103 | 126.50 |
then use the 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