cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Lizz82
Level 1

Recording Deposits For Special Orders + Opening Balances

Using Quickbooks Online in Canada.

 

I run a furniture store. Most of our products are made to order, so customers typically provide a deposit at the time of order, and pay the balance just before delivery. We record as income after delivery has been completed.

 

I found the article about retainers & deposits, and it was helpful

https://quickbooks.intuit.com/learn-support/en-us/help-article/service-items/record-retainer-deposit...

I've created a liabilities trust account called Special Order Prepayments

And a Service Income called Special Order Deposits

 

However I'm still a little uncertain how to do all my entries.

First, how do I record an opening balance for a customer (we've moved over from other software).

I have a list from my POS system with the customer names, the special order value, the deposit received to date, and the amount still owing.

E.g. Customer 1

Special Order value $2697.36

Deposit received in old software $899.12

Balance owing $1798.24

 

When we receive a new order, how will the entry differ from the above?

Part 1

Customer orders $3000 sofa

At the time of order, pays deposit of $1600

Balancing owing of $1400

 

Part 2 (2-3 months later)

Custom pays balance owing

 

Part 3

Order is delivered (1-2 weeks later)

Income is recorded as earned at this time, along with sales tax.

8 Comments 8
Amanda-B
QuickBooks Team

Recording Deposits For Special Orders + Opening Balances

Hey there Lizz82,

 

Thanks for reaching out to us here. Making sure you're recording your transactions properly is an essential step for maintaining clean books. It's important that you get the best support possible. I can point you in the right direction

 

To ensure accuracy in your books, I recommend reaching out to an accounting professional for expert advice on creating these types of transactions. They'll be able to guide you in choosing the correct transaction type as well as which accounts to affect so that your accounts can end up with the right balance. You can add your accountant to your books by going to the My Accountant tab of your QuickBooks account. You can also find an accountant that has experience using QuickBooks near you by clicking on the Find a pro to help option in that section.

 

If you have any other questions, feel free to reach out here.

Lizz82
Level 1

Recording Deposits For Special Orders + Opening Balances

Can you at least provide some guidance for just the first part?

How do you enter an opening balance for a retainer/deposit?

You have the article explaining how to take them, but it neglects to mention what to do if you have a retainer/deposit on file prior to starting with Quickbooks.

That seems like something many others would need to know as well

It's a basic part of set-up with your software.

Trish_T
QuickBooks Team

Recording Deposits For Special Orders + Opening Balances

Hi Lizz82,

 

I'd be happy to provide more information here!  In review of the article you've posted above, I see it's for QuickBooks Online U.S.  Although there are similarities between that and the Canadian version of QuickBooks Online, I suggest following this helpful guide.  You'll find when creating a liability account to track the retainers/deposits, you'll also have the option to enter an Unpaid Balance and an as of date.  Once you set up the account and create a retainer/deposit item, you'll be all set to create sales receipts or invoices for the deposits.  

 

If you have any other questions, feel free to reach back out.  We're here for you!

 

 

Lizz82
Level 1

Recording Deposits For Special Orders + Opening Balances

Thank you, this is helpful.

 

Is there a way to assign the opening balance of deposits to individual customers?

I have deposits for about 50 customers.

I have a list of their names, and the deposit on file for each as of a specific date.

Lizz82
Level 1

Recording Deposits For Special Orders + Opening Balances

duplicate reply, can't delete.

Amanda-B
QuickBooks Team

Recording Deposits For Special Orders + Opening Balances

Hey Lizz82, 

 

when you set up your customer you can enter an opening balance for that specific customer. Here is an article that I find very helpful on Manage outstanding balances for customers and suppliers in QuickBooks Online 

 

If you need anything else, feel free to reach back out.

Lizz82
Level 1

Recording Deposits For Special Orders + Opening Balances

Aren't opening balances related to the a/r for the customer?

That article doesn't mention deposits.

I need to set specific opening balances for deposits already paid by each customer.

Jen_D
Moderator

Recording Deposits For Special Orders + Opening Balances

Thanks for visiting us again about  recording customer opening balance in QuickBooks Online, @Lizz82.

 

Yes, opening balances for customers are related to Accounts Receivables. If you want to record certain opening balances use journal entries to increase the A/R balance. Here's how:

 

  1. Click the + New button in the upper-left hand corner and click Journal Entry.
  2. Add the date when you want to retroactively record the opening balance in the Journal date field.
  3. Proceed to the Account column and select Accounts Receivable in the first line.
  4. Input the amount in the Debits column.
  5. Go to the second and enter the a second account to balance the entry. You'll want to reach out to your accountant if you're unsure which account to use.
  6. Enter the name of the customer in the Name column.
  7. Press Save and close.

 

Repeat the steps for the rest of your customers. I'm also adding the same article shared by my colleague to help you manage outstanding balances for customers and suppliers in QuickBooks Online.

 

Visit us again if you need further assistance with your customer deposits. I'm here to share additional help if you need one. Have a lovely day.

 

Need to get in touch?

Contact us