cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
Joseph_N
Level 2

Entering 1000 transactions; how enter accounts efficiently?

I have a thousand transactions in more than one Bank Feed to enter into the appropriate registers. Each transaction needs to be pegged to an account in the Chart of Accounts. Doing this one by one will take weeks. Is there another way to proceed? 

3 Comments 3
BigRedConsulting
Community Champion

Entering 1000 transactions; how enter accounts efficiently?

I don't know of any way to have QB automatically assign accounts to transactions that are for new payee names.

 

I'd think I could record two or three transactions a minute, and if so that would take far less than weeks.

RCV
QuickBooks Team
QuickBooks Team

Entering 1000 transactions; how enter accounts efficiently?

It's my priority for you to categorize the downloaded bank transactions with the right account in QuickBooks Desktop, Joseph_N.

 

In QuickBooks Desktop, we can create rules to categorize transactions for things you often spend money on, like supplies or business expenses. If you are using an Express Mode, just follow the steps below:

 

  1. Go to Banking, select Bank Feeds, and then Bank Feeds Center.
  2. Tap the Rules icon.
  3. Choose the Manage Rules dropdown, then New. You can also select Edit Rule to modify an existing rule.
  4. In Add Rules Details, give the rule a name and set the conditions.
  5. In the When section, add, or remove conditions for descriptions.
  6. Provide a new name or add categories for accounts in the Do this section. 

 

You can also create Bank Feeds rules automatically by following the steps below: 

 

  1. Go to Preferences and select Checking.
  2. Tap Company Preferences then Express Mode.
  3. Choose the checkboxes for Create rules automatically and Always ask before creating a rule.
  4. From the transaction list in the Banking Center, select a name and account then select Quick Add.

 

If you have multiple transactions with the same criteria, you’ll receive a Rules Creation message. You can ignore or edit the rule. If you are using Advanced Mode, just follow the steps and details in this article: Create rules to categorize transactions in QuickBooks Desktop. From there, you can also create a rule directly on the transactions. Then, try downloading bank feed transactions again in QuickBooks Desktop.

 

For the duplicate transactions downloaded earlier, we can remove duplicate transactions from your bank feed. Here's an article you can refer to for more insights about removing duplicate transactions in QuickBooks Desktop. Before doing so, just create a backup copy if you ever run into problems so we can use your backup to restore your data.

 

Feel free to visit our Banking page for more insights about bank feeds and reconciling accounts.

 

Do you need more help completing other tasks in QuickBooks? Please let me know and I'll assist you with some guides and other pointers. Have a great day.

Fiat Lux - ASIA
Level 15

Entering 1000 transactions; how enter accounts efficiently?

@Joseph_N 

You can prepare your Deposit data with the following template

RefNumberDeposit to AccountTransaction DateDeposit MemoReceived FromFrom AccountMemoChk No.Payment MethodClassAmountCurrencyExchange Rate
1Checking01/10/202010/1/2020 Daily DepositJanie SmithConstruction IncomeMonthly125Check 15  
1Checking01/10/202010/1/2020 Daily DepositJohnny JonesConstruction IncomeMonthly302Check 15  
1Checking01/10/202010/1/2020 Daily DepositCharlie MacConstruction IncomeMonthly418Check 15  

 

then utilize one of these importer tools

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us