I connected to Investec Bank and brought in the bank transactions via sync'ing. In many of the transactions it is showing as Received, but should be Spent. How do I fix?

QuickBooks Online (QBO) depends on the accuracy of the information provided by Investec Bank. The issue lies in how the data is imported from your bank to QBO, which would require further review. Allow me to discuss this further.

For now, we need to export your affected recent transactions to a CSV file, so you can correct them and reimport the file.

Here's how:

1. On the left panel, go to Transactions.
2. Go to Bank Transactions.
3. Then, click Export to Excel.
   
   

Once done, we need to exclude the affected transactions. You don’t need to worry, since once a downloaded transaction is either accepted or excluded, QBO will stop the bank from bringing the transaction into the bank feed again.

The next thing we need to do is import back the CSV files that have been exported.

Here's how:

1. Go to Transactions.
2. Click the drop-down button beside the Link account.
3. Click Upload from the file.
   
   

Ensure that the Reserve values are checked on page 4., then follow all prompts.

Lastly, I'd like to recommend contacting our Live support team for further review of this issue. They can set up a screen-sharing session to help identify why your transactions show in the received tab instead of the spent tab.

Here's how to contact them:

1. Open your QuickBooks account using your web browser.
2. Head to the Help icon, then the Search tab.
3. Enter Contact US in the search box.
4. Click Contact Us.
5. Pick the Chat or Callback option.
   
   

Additionally, categorizing transactions helps you to organize your financial data, making it easier to track income and expenses. This can also save time during monthly reconciliations and year-end reporting.

Moreover, through reconciliation, your businesses can identify areas of excessive spending, leading to better cost management and improved profitability. It ensures that all revenue is accurately recognized in the correct periods, contributing to reliable profitability analysis.

If you need further assistance with managing your bank transactions in QBO, click the reply button. I'm always here to help.