Skip to main content
April 25, 2021
Question

When I manually uploaded my credit card transactions and reviewed, they went into the account as payments when they should have been charges. Can I move them as a batch?

  • April 25, 2021
  • 1 reply
  • 0 views
In the CSV file, should these amounts have been listed as negative numbers?

1 reply

April 25, 2021

Thanks for checking in with us, matthew-transpor. 

 

To post the bank transactions as charges, we can undo, exclude, then re-download these transactions. This way, we can post it to the correct account. First, let's undo them by following the steps below: 

  1. Click Banking, then go to the Banking tab.
  2. Go to the Review tab.
  3. Choose the transactions you'll want to undo, then click Undo.

Then, exclude them by going to the For Review tab. Then, select the transactions you'll want to exclude. Once done, click Batch actions and tick Exclude Selected. Next, manually update the bank account so transactions will re-download. Just click the Update button on the Banking page. Once done, you can assign, categorize, edit, and add your downloaded banking transactions. We can also create bank rules that automatically categorize transactions for you. Here's how:

  1. Go to the Banking menu
  2. Select the Rules tab.
  3. Tap New rule.
  4. Enter a name in the Rule field.
  5. From the For dropdown, click Money in or Money out.
  6. From the In drop-down, choose the bank or credit card account.
  7. Set the rule conditions. Decide the transaction must meet All or Any of the conditions. You can add up to 5 conditions.
  8. In the Conditions fields, specify whether the rule applies to Bank textDescription, or Amount. Then select ContainsDoesn't contain, or Is exactly to decide when how Quickbooks applies the rules.
  9. Select the settings for the rule. Hit the Transaction typePayee, and the Category to apply.
  10. Press Save.

See the Setup bank rules to categorize online banking transactions in QuickBooks Online for the steps and details. Feel free to visit our Banking page for more insights about managing your bank feeds and reconciling accounts.

 

I'd like to know how you get on after trying the steps, as I want to ensure this is resolved for you. Please reply to this post and I'll get back to you. Have a weekend.