Problem importing foreign currency bank transactions, QB thinks they are USD$

Many thanks Rose - I have established duplicate accounts in currencies and re-linked to Wise so fingers crossed all good to start reconciling.

One more query please - I need to upload credit card transactions manually from a CSV file (can't link).   
I assume QB works on a simple 3 column sheet of Date/Amount/Details?
Should expense items be shown as negative values or positive?  Thank you

One more query please - I need to upload manual credit card transactions from a CSV file (can't link).
Is this a simple 3 column spreadsheet format ie   Date/Amount/Description?
Should expense items be reflected for QB upload as negative or positive values? (eg Amex statements show expenses as positive and payments on account as CR.

Thanks for following up with the Community, Simon-PM.

I'm happy to hear RoseJillB was able to help with establishing new accounts in their correct currencies.

In regard to uploading transactions with CSV files, QuickBooks can handle 3-column or 4-column formats.

Also make sure you fine tune your CSV formatting for credit card accounts.

Here's how:

• CSV files for credit card accounts may display transactions in reverse. For example, deposits may appear as negative amounts because paying your credit card reduces your balance. Edit the CSV file and make changes if necessary.
• To confirm the transactions are imported correctly, select an appropriate credit card account when uploading your file.

If you see any error messages when uploading transactions with CSV files, be sure to do each of the following if necessary:

• Remove any zeros (0) from your file. Leave those cells blank.
• Confirm there's no transactions that display numbers in their Description columns. In the event there are some, make your necessary changes.
• Remove the word "amount" if it appears in any of your Credit or Debit column headers. These column headers should only read "Credit" and "Debit", without the word "amount."
• Make sure the dates are in one format. We recommend you using dd/mm/yyyy.
• Mac users must save their CSV files as Microsoft Windows CSV files. This is the only type that QuickBooks supports.
• Some banks add a day of the week in each transaction's Date column (for example - 20/11/2018 TUE). You'll need to remove any days of the week from your Date columns. This can be accomplished by splitting the date and your day of the week into separate columns.
• Check the file's size. QuickBooks can only handle CSV files up to 350 KB in size. In the event it's too large, try shortening your date range and downloading transactions in smaller batches.

I've also included a detailed resource about uploading transactions with CSV files which may come in handy moving forward: Manually upload transactions

Please don't hesitate to send a reply if there's any additional questions. Have a wonderful day!

Thanks for the credit card upload guidance - makes sense.

Should be simple but what I can't find is getting to the position of uploading data - there's no "Transactions" tab on any of my menus (I'm in accountant view QB Essentials online).
I've created my 'credit card' designated account in chart of accounts, and I expected it to appear under "Banking" with all my bank accounts so I can upload & add transactions - but its not there.
Please advise how I find it and upload my CSV file, thank you

It's my pleasure to guide you through the steps in uploading bank transactions manually to QuickBooks Online, Simon-PM.

You're on the right track. Just simply click Upload transactions or Link account from the Banking page, and you'll find the credit card while importing the file.

Here are the steps you can follow.

1. Go to Banking from the left menu, then Banking.
2. Click the Link account ▼drop-down, then Upload from file.
   
3. Select Drag and drop or select files and find the CSV file, then Continue.
   
4. In the QuickBooks account ▼ drop-down, select the credit card account you've created, then Continue.
5. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks, then Continue.
6. Select the transactions you would like to import, then Continue.
7. Click Yes.
8. When you accept your transactions, select Done.

You can watch this video tutorial below to learn how to do it.

Once transactions are in QuickBooks, you can match and categorize them. The transactions go into your accounts after adding them.

If you have fewer transactions, bypass the importing process. Simply go to the bank register and add them manually. Check out the Add transactions to account registers article. It contains screenshots and steps on how to add/edit entries in the register.

Let me know what part of the QuickBooks service you need more help with by commenting below. The Community forum is always open to help you @Simon-PM.

Dear Rose -- Is there any way to delete a bank feed that had the wrong currency selected and re-import it?

(My home currency is ZAR, but then importing my Canadian bank feed, I forgot to specify CAD and now everything is just in ZAR)

I haven't categorised anything so I'm not worried about doubling up on transactions if I re-import.

Would value any advice you may have!

Thanks

Heidi

Dear Rose -- Is there any way to delete a bank feed that had the wrong currency selected and re-import it?

(My home currency is ZAR, but then importing my Canadian bank feed, I forgot to specify CAD and now everything is just in ZAR)

I haven't categorised anything so I'm not worried about doubling up on transactions if I re-import.

Would value any advice you may have!

Thanks

Heidi

Thank you for your joing this thread, HeidivdS. 

To resolve the issue, you can exclude the transactions that you've imported in QuickBooks Online. 

To exclude the entries, here's how:
 

1. Go to Bank Transactions

2. Select the For Review tab.

3. Check the box for the transactions you want to exclude. 

4. Click Exclude. 

For more detailed information, you can refer to this article: Exclude a bank transaction you downloaded into QuickBooks Online.

Once the transactions are excluded, you can import them again. 

Furthermore, I'm sharing an article that will guide you on how to straighten out your books: Reconcile an account in QuickBooks Online. 

If you have any further concerns about managing your bank transactions, please don't hesitate to click the reply button below. I'll get back to you as soon as possible.