Skip to main content
R
Renarda
October 29, 2022
Question

Rule for Bank Deposit with splits for multiple Customers

  • October 29, 2022
  • 1 reply
  • 0 views

My bank collects condo association dues monthly from multiple units into one large deposit (same amount each month for each unit though different units have different dues amounts) and sends me an IIF file that breaks the large deposit into multiple Customers.  QuickBooks Online does not process IIF files, so I created a Bank Deposit with split lines for each Customer, but typing this in every month is tedious and my level of QuickBooks Online doesn't support recurring transactions.  Can someone advise me how to create a Rule for a Bank Deposit with a different Customer for each split line?  Or is there a different approach altogether that would work better?  

1 reply

M
MirriamM
October 30, 2022

Hello there, @Renarda. Thanks for reaching out to us. 

 

Right now, able to create a bank rule to split a bank deposit for different customers is not an option in QuickBooks Online (QBO). In the meantime, you may need to split bank deposit transactions manually. 

 

 I know how you wanted to utilize the bank rules feature to help you save time and reduce categorization. With this, I recommend sending feedback to our product development team. 

 

To send feedback, follow the below steps:

 

  1. Go to the Gear icon at the top.
  2. Select Feedback.
  3. Enter your comments or product suggestions. 
  4. Then select Next to submit feedback.

 

For more details on how the bank rules feature works, see this article: Set up bank rules to categorize online banking transactions in QuickBooks Online.

 

Then, use this reference to ensure your account are balanced and accurate: Reconcile an account in QuickBooks Online. 

 

I'm always around if you have other questions about managing your bank transactions in QBO. You can drop a comment below, and I'll gladly help. Have a great day.

Terms & ConditionsAccessibility statement