Skip to main content
M
midnightbyverben
September 14, 2024
Question

How to add old bank transactions and have them not labeled as 'cash'

  • September 14, 2024
  • 1 reply
  • 0 views
My bank account was unsynced for months and now I have to add every manually. How do I add these and not have the system label them as 'cash'?

1 reply

S
Sherrie_F
September 14, 2024

Your interest in choosing QuickBooks as part of your business venture is highly appreciated, Verbena. You can import your transactions through the Transactions tab and add them to your bank account.

 

Beforehand, it's important to note that all added transactions will be listed as cash in QuickBooks Self-Employed (QBSE). However, you can manually import them directly from your bank. I'd be happy to guide you through the process.

  

  1. On the left navigational panel, look for the Transactions tab and click the drop-down arrow to add a transaction.
  2. Choose Import transactions.
  3. Pick a Bank type. Then, click Import older transactions.
  4. Enter all the necessary information. 
  5. Select Browse and find the file you downloaded from your bank (usually in your Downloads folder).
  6. Review the column headers and data. Ensure that the CSV file's Date, Description, and Amount columns match the columns and order in QuickBooks. The other column headers can be in any order.
  7. Click Continue to complete the import.

 

For visual reference, I've added some screenshots below:

 

 

 

Furthermore, you can read this article for a detailed process and more information about the CSV file format: Manually import transactions into QBSE. 

 

Additionally, here's an article you can browse to learn how to create and use rules to categorize recent and past transactions in QBSE that can come in handy moving forward: Create rules to speed up reviews in QuickBooks Self-Employed.

 

You can always have me if you have other queries about manually adding your transactions in QBSE. Let me know if you have any other tasks that you'd like me to help you with.

M
midnightbyverbenAuthor
September 14, 2024

What if these transactions are over 90 days old and your bank doesn't have a CSV option because of how old they are?

I
Ivan_G
September 14, 2024

There are two ways you can consider if you can't download a CSV file of your bank transactions, midnight. I'll gladly share them with you.

 

If your bank data is unavailable for download, review your bank statement and manually enter the transactions you need to record into QuickBooks. Here's how:

 

  1. Open your QuickBooks Self-Employed account.
  2. Go to the Transactions menu and select Add transactions.
  3. Enter the transaction's Date, Amount, and Description.
  4. Pick the accurate category of the transaction from the Select a category option.
  5. Double-check everything, and once done, hit Save.

 

For additional reference about this process, kindly check out this link: Manually add transactions in QuickBooks Self-Employed.

 

The second option is to directly contact your financial institution so you can request a CSV copy of your data. This way, you can import and manage them in QuickBooks.

 

I've also added some resources that you can access if you want to reconnect your bank account and learn more about the proper way of organizing your data in QuickBooks:

 

 

Your concerns matter to us. If you have more questions about your bank transactions and importing procedures or need help handling your data in QuickBooks, tag me on this thread. I'll be around and ready to help you out.

Terms & ConditionsAccessibility statement