Banking

You have me to help you fix this issue, vasante01.

When we manually import transactions into QuickBooks, we have two options on how to do it. We can either use 3 columns or 4 columns.

In your case, since you have credit and debit, we'll have to use the 4 columns option. Then, make sure to map the transactions to the correct field.

We can fix this issue by deleting the downloaded transactions and then import them again. Let me guide you with these steps:

1. From the Banking tab, select Banking.
2. Go to the For Review tab.
3. Select the transactions.
4. In the Batch actions drop-down, select Exclude selected.
5. Go to the Excluded tab.
6. Tick the transactions and then select Delete in the Batch actions drop-down.

Afterward, we'll have to import them again.

1. Click File Upload in the Banking page.
2. Select Browse and then locate the file.
3. Select Open, and then Next.
4. Choose which account you want to upload the transactions.
5. Click Next.
6. Under CSV file has amount in: link, select Column 2.
7. Filter the Date and Description.
8. In the Money Spent field, select your rent expense.
9. Select a debit in the Money Received drop-down.
10. Click Next.
11. Review the transactions, and then Next.
12. Select Yes.

Then, you're good to categorize and reconcile them.

I'm just a post away if there's anything that I can help. Stay safe!