cancel
Showing results for 
Search instead for 
Did you mean: 
PARKSG
Level 2

HOW TO CODING THE PREPAID TO THE 3RD PARTY ON BEHALF OF THE CUSTOMER

Dear All,

Firstly, I would appreciate all your advice. It's really big help for me as new for accounting and QBO.

 

Today, my question is ->

My customer wants us to pay to the 3rd party on behalf of them at first. (in July)

And we created the invoice in July including the prepayment. (in July)

The customer will pay in Aug or Sep, we are not sure btw they will do it surely :P

 

1. How I need to record at this prepayment on behalf of the customer at our end.

2. After receiving the full amount of the invoice(including the prepyment), how I need to coding in Aug or Sep.

Hope I can get detailed reply caz I am really new and not specialist for QBO. Thanks indeed! 

Solved
Best answer August 04, 2021

Best Answers
JenoP
QuickBooks Team

HOW TO CODING THE PREPAID TO THE 3RD PARTY ON BEHALF OF THE CUSTOMER

Thanks for getting back to us with more details about the version that you're using, PARKSG.

 

You'll want to upgrade to QuickBooks Online Plus to be able to use the Projects feature. You can also activate the Billable Expense feature in QBO Plus, which is another way of recording the payments that you made on behalf of the customer.

 

Here's how:

 

  1. Go to the Gear or Settings ⚙ and click Account and settings.
  2. Proceed to the Billing & Subscription tab.
  3. Make sure that your payment info is up-to-date.
  4. Go to the QuickBooks Online section, then select Upgrade your plan.
  5. Review the available plans and then select Choose plan.
  6. Follow the on-screen steps to upgrade your plan.

 

Here's an article about this for more details: Upgrade or Downgrade your QuickBooks Online Subscription.

 

Although, I would also recommend reaching out to your accountant for further advice on this matter if you wish to stay in your current subscription. 

 

Don't hesitate to reply to let me know if you anything else when working in QBO. I'd be glad to get back here and offer my help to you again. 

 

 

View solution in original post

3 Comments 3
MariaSoledadG
QuickBooks Team

HOW TO CODING THE PREPAID TO THE 3RD PARTY ON BEHALF OF THE CUSTOMER

Recording the prepayment and coding the payment may be complex but I'm here to guide you how, PARKSG.

 

You can utilize our Projects feature so you can record and separate the transactions of a specific customer and supplier. Please know that this feature is only available in QuickBooks Online Plus. To turn on projects, follow the steps below:

  1. Click the Gear ⚙ icon, then select Account and settings.
  2. Go to the Advanced tab.
  3. Find the Projects section and select Edit ✎ to expand it.
  4. Turn on Organise all job-related activity in one place.
  5. Click Save and close your settings.

Once done, enter Bank Deposits to show money received from the Customer, recording them to the Accounts Receivable (A/R) account increases the Customer balance until you enter the final Invoice.

  1. Click + New.
  2. Select Bank Deposit.
  3. Select the Bank Account the money is received into and the Payment Date.
  4. Scroll down to the Add funds to this deposit section, enter information as follows:
    • RECEIVED FROM:  Customer Name
    • ACCOUNT:  Debtors (or Accounts Receivable)
    • AMOUNT:  Enter amount paid by the Customer.
  5. Click Save and close.
  6. Repeat steps 1a-1d for each payment received from the Customer in advance of raising the Invoice.

Then, enter the invoice:

  1. Click + New.
  2. Select Invoice.
  3. Fill out the necessary information, including the tax information.
  4. Click Save and close.

Next, apply prepayments to the invoice: 

  1. Locate and open the Invoice.
  2. In the top right-hand corner, click Receive payment.
  3. In Outstanding Transactions section, tick/select the Invoices you want to associate with the prepayments.
  4. In the Credit section, tick/select the relevant Payments created in Step 1, above.
  5. If there is a balance due on the Bill, you can pay the remainder by editing the Payment amount against the Invoice. If you don't want to pay the remaining amount, edit the Amount figure above the right-hand side of the Outstanding Transactions section.
  6. Click Save and close.

You'll want to track payments against the Current Liability account. You can consult your Accounting professional to see if they have a preferred method of recording these transactions.

  1. Create a Current Liability account to track prepayments.
    1. Click Accounting in the left-hand navigation bar, choose Chart of Accounts.
    2. In Chart of Accounts, click the New button.
    3. From the Account Type drop-down list, choose Current Liabilities.
    4. From the Detail Type drop-down list, choose Current Liabilities.
    5. Enter the Account Name, e.g. Customer Prepayments, click OK.
      • Tip:  If a small number of customers pay you in this way, you could create Sub-Accounts for each Customer, as this may make it easier to track amounts paid
  2. Create a Service item, that posts to the above Account
    1. Go to the Gear ⚙ icon, then select Products and Services.
    2. Click the New button, select Service.
    3. Enter a Name, e.g. Customer Pre-Payments.
    4. Go to the 'Income Account' field, from the drop-down select the account created in Step 1, above.
    5. Click Save and Close.
  3. Enter Sales Receipts for each payment received in advance of the Invoice, posting to the new Service item.
    1. Select + New.
    2. Select Sales Receipt.
    3. Select the Customer Name, Payment Date, and the Bank Account the money was received in to.
    4. In the PRODUCT/SERVICE field, select the Prepayments account created in Step 2, above.
    5. In the Amount column enter the Amount received.
    6. Click Save and close.
    7. Repeat steps 3 #1 - 3 #5.  for subsequent payments made in advance of the Invoice being raised.
  4. Enter the Invoice, ensuring the prepayments are taken into account.  TIP - See the last section at the bottom of this article for a report that shows the amount of prepayments made.
    1. Select + New.
    2. Select Invoice.
    3. Enter Customer details as normal, with line items detailing the Services provided, select the relevant VAT code(s).
    4. On the last line item, select the Customer prepayments item created in Step 2, above.
    5. Enter the amount of prepayments as a Negative value..
      • IMPORTANT - The amount in Step 4 #4 needs to be entered as a negative with a tax code selected, as this ensures tax isn't counted twice.
  5. Pay the Invoice balance - If there is a balance due after the prepayment is applied.
    1. Locate and open the Invoice.
    2. In the top right-hand corner, click Receive payment button.
    3. Enter the amount being paid in the Amount box.
    4. Click Save and close.

To help identify the amount of prepayments made to a Supplier, you can run the following report:

  1. Click Accounting in the left-hand navigation bar, locate the Customer Prepayments account.
  2. In the Actions column to the right-hand side, click the drop-down next to Account history, select Run Report.
  3. Select the required date range by clicking the Report period drop-down
  4. If you have all Customer prepayments going to the same account, click the Group by drop-down and select Name.
  5. Click Run report.

For your reference, you can run reports to show the information you need. Read this article so you'll be guided: Run Reports in QuickBooks Online.

 

Let me know if you need anything else about prepayments. The Community is always right here for you to assist. 

PARKSG
Level 2

HOW TO CODING THE PREPAID TO THE 3RD PARTY ON BEHALF OF THE CUSTOMER

@MariaSoledadG Wow, thanks for your support indeed, but unluckily we are using QBO Essential only...ㅜㅜ

JenoP
QuickBooks Team

HOW TO CODING THE PREPAID TO THE 3RD PARTY ON BEHALF OF THE CUSTOMER

Thanks for getting back to us with more details about the version that you're using, PARKSG.

 

You'll want to upgrade to QuickBooks Online Plus to be able to use the Projects feature. You can also activate the Billable Expense feature in QBO Plus, which is another way of recording the payments that you made on behalf of the customer.

 

Here's how:

 

  1. Go to the Gear or Settings ⚙ and click Account and settings.
  2. Proceed to the Billing & Subscription tab.
  3. Make sure that your payment info is up-to-date.
  4. Go to the QuickBooks Online section, then select Upgrade your plan.
  5. Review the available plans and then select Choose plan.
  6. Follow the on-screen steps to upgrade your plan.

 

Here's an article about this for more details: Upgrade or Downgrade your QuickBooks Online Subscription.

 

Although, I would also recommend reaching out to your accountant for further advice on this matter if you wish to stay in your current subscription. 

 

Don't hesitate to reply to let me know if you anything else when working in QBO. I'd be glad to get back here and offer my help to you again. 

 

 

View solution in original post