Skip to main content
April 14, 2020
Question

Subscriptions fees spread across the year

  • April 14, 2020
  • 1 reply
  • 0 views

Hi, after some advice please. We are a football club with around 500 members. I moved to quickbooks online after using a database for years.

 

for example, I uploaded an invoice against each customer of £250, then they repay it across 11 months of £25. I couldn't see the best way to allocate those payments when they come in via BACS and card payments. I am hoping not to have to go onto every one and link it up, I thought it would match them once I had made the link to the donor account initially. I seem to have to accept/amend each payment that is downloaded from the bank and then manually add it as a payment which is taking longer that it did when I held them on a database.

 

Before the start of next season, I am hoping to find the best/most time effective/streamlined way of doing this so wanted advice before I create all of those invoices again.

 

Ive already lost the link to Yorkshire bank so that is taking longer now as i have to download the info rather than just update the bank.

 

Thanks in Advance

 

 

1 reply

AlcaeusF
April 14, 2020

Welcome to the QuickBooks family, @BCFC.

 

I can share some information about using bank feeds in QuickBooks Online. Currently, an automated way to link each downloaded payment to individual invoices is unavailable.

 

You can match each downloaded transaction manually from Bank feeds directly to the open invoices. Please note that payments applied to an open sales transaction will directly post to your bank register.

 

Here are the steps:

 

  1. On the left navigation bar, go to Banking.
  2. Click the bank account.
  3. Select the partial payment.
  4. Choose the Find match option. 
  5. Put a checkmark on the open invoice.
  6. Hit Save
  7. View the Transaction List section from the customer profile. 

Meanwhile, I've attached some articles you can use to learn more about using Bank Feeds, as well as matching transactions:

 

If you have additional questions or concerns while working in QBO, leave a comment below. I’ll be happy to help you out.