Bank Rules when Importing transactions

pst4nley · ‎January 15, 2020

Hi,

Each time I import transactions via a CSV file none of the existing rules are applied. I have to review the new transactions. I then click on the Add Rule link for each transaction that should have a rule, only to be told "A rule matching these criteria already exists" to which I shout "Well why have you not applied them then?!!"

Is this a know problem with imported transactions?

Paul.

Charies_M · ‎January 16, 2020

I'm glad you came back, pst4nley.

You can choose to apply the rule to past transactions. I'd be happy to walk you through the steps below:

Go to the Gear icon and then click Rules.
Select Create Rule.
Fill in the necessary information. Select to check the Match exactly checkbox if you want QuickBooks to only use the rule when transactions match exactly.
If you want the rule to apply to transactions you've already categorized, select to check the Also apply to past transactions checkbox.
Click Save.

Here's a reference that you can read through about creating rules in QuickBooks Self-Employed.

Feel free to reach back to me for any questions. I'm here to provide further assistance at any time. Have a good one.

View solution in original post

JasroV · ‎January 15, 2020

Hi there, @pst4nley.

QuickBooks Self-Employed (QBSE) imports CSV file that use either a 3-column or 4- column format. These are the columns QBSE can import.

The 3 Columns template has columns for Date, Description, and the Amount of the transaction.

Then the 4 Columns template has a Date, Description, and a both Credit and Debit column.

Thus, the existing rule from the transaction will not be imported. You'll have to manually apply those banking rules to avoid any duplicates and error in the future.

Then, in case you'll need to learn how some tips on managing your QBSE, you can always visit our Help articles page for reference.

I'll be around if you need more help. Take care!

pst4nley · ‎January 16, 2020

Thanks Jasro.

What's the best way to manually apply rules after the import?

Charies_M · ‎January 16, 2020

I'm glad you came back, pst4nley.

You can choose to apply the rule to past transactions. I'd be happy to walk you through the steps below:

Go to the Gear icon and then click Rules.
Select Create Rule.
Fill in the necessary information. Select to check the Match exactly checkbox if you want QuickBooks to only use the rule when transactions match exactly.
If you want the rule to apply to transactions you've already categorized, select to check the Also apply to past transactions checkbox.
Click Save.

Here's a reference that you can read through about creating rules in QuickBooks Self-Employed.

Feel free to reach back to me for any questions. I'm here to provide further assistance at any time. Have a good one.

Topics

Training

Community

Resources

Bank Rules when Importing transactions