Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Professional Tips and Workarounds for QuickBooks Online
Professional Tips and Workarounds for QuickBooks Online

Professional Tips and Workarounds for QuickBooks Online: Improve your QuickBooks Online and bookkeeping skills using advanced techniques and best practices

eBook
€8.99 €19.99
Paperback
€24.99
Subscription
Free Trial
Renews at €18.99p/m

What do you get with Print?

Product feature icon Instant access to your digital eBook copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Product feature icon AI Assistant (beta) to help accelerate your learning
OR
Modal Close icon
Payment Processing...
tick Completed

Shipping Address

Billing Address

Shipping Methods
Table of content icon View table of contents Preview book icon Preview Book

Professional Tips and Workarounds for QuickBooks Online

Chapter 1: Creating and Reviewing Opening Balances in QuickBooks Online

As described in the preface of this book, QuickBooks Online is a cloud-hosted accounting software solution for small to medium-sized businesses. Accountants and bookkeepers can assist their clients by being able to access all the information they need at any time.

Opening balances reflect the financial position of a business at the point when QuickBooks Online is brought into use. Where a business has only just been set up and they choose to use QuickBooks from the very beginning, there will not be any opening balances to speak of except for cash or equipment introduced by the business owners.

Where a business has been operating for some time and has perhaps used spreadsheets or other accounting software in the past, there will be a financial history that results in values that will affect the balance sheet in different ways.

It is very important, especially when moving from one method of accounting to another, to ensure there is continuity. Without a correcting starting position, future profits could be over or understated, and the values filed in various tax returns could be incorrect.

In this chapter, we will cover the following topics:

  • Should opening balances be in place before using QuickBooks?
  • Opening balances – Customers
  • Opening balances – Suppliers
  • Opening balances – Bank
  • Opening balances – VAT/GST/Sales Tax
  • Other opening balances

Should opening balances be in place before using QuickBooks?

Before we explore opening balances, we need to know whether it is necessary for our opening balances to be in order when we make the switch from our old method of keeping books to QuickBooks.

The simple answer to this question is no. As soon as you have a subscription in place and set QuickBooks Online up with the required settings, you are likely to want to start creating customer invoices before you do much else.

However, it is best to get some opening balances in place as soon as possible. As customers start to pay for products and services supplied before QuickBooks is in use, it is important to have a record of any of those unpaid amounts in place. This will also be the case when it is time to pay suppliers for amounts owed against historic bills.

We can build our opening balances in stages – it is not necessary to do it all at once. In some instances, it is not possible to deal with all the opening balances because all the information required is not readily available. Therefore, we can put into place the values that are easy to deal with, such as the amounts owed by customers and to suppliers.

What dates are used for opening balances?

Before we answer this question, it is important consider the date you start using QuickBooks Online. You can of course start using QuickBooks at any time, but it can generally make life easier to do so when a clear "line in the sand" has been drawn.

The following are good starting points for a new QuickBooks Online file:

  • Any time for a new business (no historical transactions to worry about)
  • Start of new financial year/tax year
  • Start of new VAT/GST/Sales tax period

Using these starting positions can make life a little easier when preparing financial statements and tax returns. Otherwise, data may need to be merged from two systems, which can increase time consumption and the cost of work required.

Once you select the start date, ensure the financial year date is set correctly in QuickBooks. To do this, select the gear icon found in the top right of the main screen menus and choose Account and settings from the YOUR COMPANY list.

Figure 1.1 – Selecting the financial period start date

Figure 1.1 – Selecting the financial period start date

From within the Advanced tab, we select the first month of the financial year. In this example, the year-end is March 31, so the first month is set as April. This company is going to use QuickBooks from April 1, 2021.

Now that we have selected our start date, we will visit some examples of opening balances.

Opening balances – Customers

At any given point, it is highly likely that a business is owed money from customers for goods and services already provided in a previous period; this needs to be considered when a business decides to change its bookkeeping system.

There are various methods to create the opening balances for amounts owed from customers, but we will stick with the one that is advised by most professionals.

A business should have a list of the invoices sent to customers and of those that remain unpaid at the date they start using QuickBooks. Taking that list, we will already have the following:

  • Customer name
  • Invoice date
  • Invoice number
  • Net charge
  • VAT/GST/sales Tax
  • Invoice total

From the preceding list of items, we have pretty much all the information we need to create our opening customer balances in QuickBooks. That will be done by creating invoices in QuickBooks that reflect those that are unpaid. In addition to the items listed, we will need to add either terms or a due date, and we will need to use product/service item information. But how do we decide on which product/service code to use?

Which Product/Service Item to use

Product/Service items dictate how the values entered on invoices are presented in different reports.

You can use one of the default items, but it is advisable to create a specific service item for invoices that are created that form part of your opening balances. This makes them easier to identify and will also assist with the reconciliation process when checking that opening balances have been completed.

The following figure shows how the Product/Service code should be created.

Figure 1.2 – Item/Service code for opening balance

Figure 1.2 – Item/Service code for opening balance

Notice the Income account value selected here is Opening Balance Equity. This account name may vary in different regions and could be Retained profit balance forward account. The important thing to consider here is that this account forms part of our Double-Entry when dealing with our opening balances.

You can create and use your own balance sheet account. If you do, ensure it is an Equity account, with a detail type of Accumulated adjustments.

When we create our opening balances for customers using invoices, the following accounts will be affected:

  • Debit: Debtors/Accounts receivable (total amount of unpaid invoice)
  • Credit: Opening balance equity
  • Credit: VAT/GST/sales tax if applicable

    Important Note

    VAT only needs to be split on the invoice for the opening balances for Cash Accounting purposes. For Standard VAT accounting, the invoices can be entered gross using No VAT. Any further adjustments for VAT on Customer/Supplier balances could be made using Journal entry. (This is explained in the Opening Balances – VAT section.)

If VAT (or the sales tax appropriate for your region) is submitted on a cash basis or for any other reason the invoice was not reported on the previous return, the invoice should be recorded exclusive of tax. Below is an example of a single opening balance customer invoice:

Figure 1.3 – Customer invoice screen

Figure 1.3 – Customer invoice screen

The preceding image reflects one of the invoices owed from a customer named Farscape Applications as of March 31, 2021. The invoice date used is per the original invoice sent that is unpaid.

This invoice is for a company filing VAT/GST on a cash basis, so the sales tax has not been filed. For standard VAT accounting where the tax had already been filed, the amount would be £600 inclusive using NO VAT/NO TAX, which can vary depending on the region you are working in.

If this customer owes £1,800 for 3 months, three separate invoices should be created. Separate invoices should be created because this will help ensure that future payments are allocated correctly. Also, if payment reminders are required, or statements are sent to customers, it will be easier for customers to agree on the values displayed.

To complete the creation of our opening customer balances, separate invoices should be created for each unpaid invoice for all customers. If you have a lot of unpaid customer balances, you can save a lot of time by importing the data using a .csv file.

Depending on your region, you may not have the ability within QuickBooks alone to import invoices. The Import Data option in the UK version appears as follows.

Figure 1.4 – Import Data options (UK)

Figure 1.4 – Import Data options (UK)

If you do have a large amount of unpaid customer invoices and the import feature is not available, it may be worth temporarily subscribing to an app such as SaasAnt Transactions Importer – details can be found at www.apps.com.

After all the customer invoices have been created (by manual input or data import), we must run some reports to check whether our unpaid customer balances are correct:

  • Accounts receivable aging summary report
  • Accounts receivable aging detail report
  • Trial balance

All reports can found within the reports center, which can be accessed from the left-hand navigation pane. You will also be able to search for reports from this area. The first two reports listed above should be run and checked as per the last period. In this chapter, we considered that our company will start using QuickBooks from April 1, 2021, so the reports should be run and checked as of March 31, 2021. The summary will provide the totals owed by each customer and the detailed report will list all unpaid invoices.

The trial balance report will display a summary of accounts used so far, up to the date we run the report, which in this scenario is March 31, 2021:

Figure 1.5 – Trial balance report after customer opening balances are updated

Figure 1.5 – Trial balance report after customer opening balances are updated

  • Debtors: The total owed by customers that will agree to the accounts receivable reports
  • VAT Control: The value of sales taxes not yet filed (GST/sales tax)
  • Opening Balance Equity: The account linked to the product/service used for opening balances

Opening customer balances – Summary

  • Create invoices for all unpaid values that reflect historical invoices sent.
  • Use the original dates and invoice numbers.
  • Enter values gross if taxes filed; enter net + tax if the amounts have not previously been included on VAT/GST returns.
  • Save time importing when there are large volumes to deal with.

With customer balances now complete, it is time to look at opening balances for suppliers.

Opening balances – Suppliers

Dealing with opening balances for suppliers is similar to the method used for our customer balances. This time, we will be creating supplier bills for the amounts due. Again, there are different methods for creating opening balances, but we will stick with one preferred by professional advisors.

Creating supplier bills that reflect exactly what was owed before QuickBooks was put into use means that there will be values that match direct debits that appear on bank feeds, and there will be bills that we can agree to supplier statements:

Figure 1.6 – Supplier bill input screen

Figure 1.6 – Supplier bill input screen

The fields within the red boxes are mandatory when adding the supplier bill. Note the same chart of account code linked to the service item for customer invoices, that is Opening Balance Equity, is being used. All opening balance adjustments should affect the same account.

Just as in the case with customer balances, the VAT/GST will need to be accounted for if the amounts have not been included on previously filed returns. If the bill had already been included within a filed VAT return, it would have been entered as £360 NO VAT.

After all supplier bills have been entered (and if necessary, any supplier credits), the following reports should be checked to the date before the QuickBooks start date. For example, if starting from April 1, 2021, all the reports will be run to the date March 31, 2021:

  • Accounts payable aging summary
  • Accounts payable aging detail
  • Trial balance

The first two reports should be compared to the details held within our old accounting records. It's important that the amount that QuickBooks reports as being owed to suppliers at our chosen start date is as expected.

The trial balance report will now include creditors that will agree to the totals on the accounts payable report. In the example shown in the following figure, VAT Control has been reduced to reflect the purchase tax claimed on supplier bills:

Figure 1.7 – Trial Balance report after supplier balances updated

Figure 1.7 – Trial Balance report after supplier balances updated

With opening balances in place for customers and suppliers, it is now time to look at ensuring the opening balances for any bank accounts are correct.

Opening balances – Bank

When dealing with the opening bank balance, the following must be taken into consideration:

  • The balance per the bank statement at the start of the day when QuickBooks is put into use – in this example, the closing cleared balance on March 31 was £5,000.
  • Payments made (checks) or deposits received that were originally recorded before the date QuickBooks was put into use, but have not yet cleared the banking system.
  • Whether a live bank feed is in place for the bank account.

Dealing with the last point, in some instances, when a bank account is connected to QuickBooks Online, an opening balance is automatically created. Sometimes this opening balance will be OK; however, sometimes it will be incorrect and will need to be deleted.

There are a couple of ways to check to see whether an opening balance has been automatically created. If no bank reconciliations have been performed against a bank account, there will be a beginning balance within the reconciliation screen as shown here, where the beginning balance will normally be 0.00:

Figure 1.8 – Bank reconciliation

Figure 1.8 – Bank reconciliation

The other way to check whether an opening balance has been created by connecting a bank feed is to run the trial balance report for all dates and then click on the value associated with Opening Balance Equity or Retained profit balance forward.

This will display a list of all entries made to this account. Where an automatic opening balance has been created, it should be clearly visible in the list as shown in the following figure.

Figure 1.9 – Opening Balance Equity transaction report

Figure 1.9 – Opening Balance Equity transaction report

What if no opening balance is created?

If there is no chart of account category in place, one will need to be created. If a bank account has been set up, then choose to edit it. Simply enter the cleared balance as per the bank statement date the day before QuickBooks was put into place:

Figure 1.10 – Editing the chart of accounts code with the opening balance

Figure 1.10 – Editing the chart of accounts code with the opening balance

The double-entry to the value to be entered in Balance will affect the Opening Balance Equity account. If the bank account is overdrawn, be sure to enter a negative value.

Tip

Using the balance within the chart of account code to account for the cleared balance will automatically mark the account as reconciled at the specified date.

What about uncleared checks and deposits?

Where any checks were written out before QuickBooks was put into place and there were funds received that had not cleared the bank prior to setting up QuickBooks, entries are required so that they can match future transactions as they appear on the bank feed.

To do this, a journal entry is required. Checks that have not yet cleared the bank will need to credit the bank, and deposits will require debits. This information should be obtainable from the last bank reconciliation from the accounting system in use prior to QuickBooks.

In the example shown in the next figure, the following entries had not cleared the bank as of March 31, 2021:

  • Check 000345 dated February 16, 2021, for £300
  • Deposit 000222 dated March 31, 2021, for £250
Figure 1.11 – Using a journal to account for uncleared bank entries

Figure 1.11 – Using a journal to account for uncleared bank entries

The double-entry is always made to the Opening Balance Equity account.

With all the entries made that reflect the opening bank balance, again run the trial balance to the day before QuickBooks was brought into use, that is March 31, 2021.

Figure 1.12 – Trial Balance report after opening bank balances

Figure 1.12 – Trial Balance report after opening bank balances

The bank balance here of £4,950 reflects the following values:

  • Balance of £5,000 as per the bank statement as of March 31.
  • Less the uncleared check for £300.
  • Add the uncleared deposit of £250.

To summarize, £5,000 - £300 + £250 = £4,950.

With the bank added, we can now add a credit card balance owed for £750 as follows:

Figure 1.13 – Opening balance for credit card

Figure 1.13 – Opening balance for credit card

Opening balances – VAT/GST/sales tax

If the business using QuickBooks is not VAT registered or similar, then you will not have to enter any opening balances for VAT. However, for a business that files VAT returns, we must consider the following:

  • Is the date we start using QuickBooks in line with a new VAT period?
  • Is there an overlap? For example, 2 months from the old system and 1 month from the QuickBooks start date will be used to file the next quarter.
  • Is there any unpaid VAT from previously filed returns?
  • Is VAT filed on a cash basis (dates of payments) or standard accrual basis using the dates of invoices and bills?

In the example within this book, the opening balances have been created for a business that files VAT on a cash basis. The unpaid customer and supplier balances have been entered net plus VAT, and that has resulted in the balance appearing in VAT control.

If all VAT has been paid, and there is no overlap at all, there would be nothing further to do. However, this is going to be unlikely.

Let's look first at VAT already filed but not yet paid. The example here is for a UK company but the principle will work the same in other regions – there will just be different terminology and tax rates.

If the VAT was filed, or about to be filed to March 31, but QuickBooks was only put into use on April 1, there will not be any information held in the software for the quarter January–March to enable us to create a return. However, we can fix that.

First, check whether the VAT settings reflect the start of the VAT period not filed/paid. So, here we have January selected even though we started using QuickBooks in April.

Figure 1.14 – VAT settings

Figure 1.14 – VAT settings

What we will need to do next is take information from the VAT return that has already been filed, or information from our old accounting system, so that we have the following:

  • Summary of sales with a specific tax rate applied and amount of tax
  • Summary of purchases with a specific tax rate applied and amount of tax

With the preceding information to hand, we will create a journal dated to the last quarter, and this should be entered as shown here.

Figure 1.15 – Journal entry required for VAT balances

Figure 1.15 – Journal entry required for VAT balances

Every journal line must be posted to the same account Opening Balance Equity. All values that need to appear on the return must have a VAT rate applied and this will add a VAT value at the bottom of the journal.

The balancing line on this journal is entered into the same chart of account code but does not have a VAT rate applied.

The result of creating the preceding journal will affect our VAT return, as shown in the following figure.

Tip

When creating journals like this, it is possible to attach documents (option available at the bottom left of the journal screen). It is a good idea to attach your spreadsheet workings in case you need to refer to them later.

Figure 1.16 – VAT return summary after the opening balances are updated

Figure 1.16 – VAT return summary after the opening balances are updated

We can see that entering a summary of data from a previous period into the journal will populate the VAT return exactly as required. If the VAT return has already been filed with the authorities, it can be manually marked as filed, where the payment can be recorded later.

If you have not filed the VAT return yet for the last quarter, we will now be able to submit the return digitally (if available in your region).

If the business had more than one VAT period unpaid, journals can be created for every period and the VAT returns recreated this way. You must work on the oldest period first, because it would not be possible to create a return for an earlier period once a return has been filed for a later period.

If there was an overlap between the VAT period and the date the business started to use QuickBooks, then a journal could be created that reflects sales and purchases for 2 months from the old system, and sales and purchases from QuickBooks would be used for the third month of the quarter.

As with all other opening balances, we should check our trial balance to see what the effect of making entries has made.

Figure 1.17 – Trial Balance report after adjustments made for VAT

Figure 1.17 – Trial Balance report after adjustments made for VAT

Creating the journal for the VAT has increased liability in the VAT control account and reduced the Opening Balance Equity account further. When all opening balances have been entered, the Opening Balance Equity account should finally balance to zero.

Let's move on to look at more common opening balances that may be required.

Inventory (stock)

Product/Service items for inventory can be imported – see Figure 1.4. Stock that is imported will be valued by multiplying the quantity on the import sheet by the purchase cost price set against an item.

This creates an opening stock adjustment, which is similar to a journal entry. One side of the entry will debit the Stock Asset account, and the other side of the entry will credit Opening Balance Equity.

Opening Balances – Other

So far, we have looked at opening balances where information should be readily available to business owners: the cash in the bank, what our customers owe, what is owed to suppliers, and the current VAT/GST/sales tax position. However, other values that appear on the balance sheet may require further investigation.

In some instances, the accountant may not have finalized the accounts for the previous financial year, so the opening balances cannot be completed until there is a balance sheet that all figures can be agreed to.

The following sections contain details of the different types of opening balances. They can all be set up in the same way; this will be explained toward the end of this chapter.

Other business taxes

This is the balance of tax, insurance, and pension contributions that has been deducted from employees, and the corporation tax payable by the company.

Fixed assets (Plant and Machinery)

The value of all assets held by the company. This usually includes the original cost and provision for depreciation already made. This information is found on the fixed asset register (This is often held by the accountant).

Loans and Hire Purchase Agreements

The current balance owed on any loans that the company has in place. This will include the original loan value, less payments to date, and accrued interest.

Shareholdings

This is the value of shares in place. This information will be found on the last set of completed accounts.

Director's loans

The balance funds owed to the director, or, in some cases, funds owed from a director if the director's loan is overdrawn.

Provisions for prepayments and accruals

These values are often calculated by the accountant and relate to income and expenditure that will be adjusted in other periods: for example, an annual subscription paid, 6 months of which will cover a different financial year.

The opening balances for these categories can be created as follows.

When creating/editing a chart of account code and adding a balance as at a specified date, this method can save time as you are creating the opening balance at the same time as creating/editing the chart of account code.

Figure 1.18 – Editing the chart of account category with the opening balance

Figure 1.18 – Editing the chart of account category with the opening balance

If you have all the necessary chart of account codes in place, it will be quicker to use a journal entry to create the opening balances. All liabilities (monies owed to others) need to be entered as credits and all assets are entered as debits.

Figure 1.19 – Using a journal to edit further opening balances

Figure 1.19 – Using a journal to edit further opening balances

The final balancing line will be entered into Opening Balance Equity.

After creating this journal entry, the trial balance report appears as follows:

Figure 1.20 – Checking the Trial Balance report

Figure 1.20 – Checking the Trial Balance report

After making all the entries to this company so far, the balance within Opening Balance Equity is £4,350, but it should balance to zero once complete, so what could be missing?

If the business has been trading for over a year, there should be a balance in the Retained Earnings account, which is a result of the cumulative profit/loss of the business in previous years. Errors could also have been made along the way, which is why this account contains a balance.

Using the example that has been worked on in this chapter, it has been found that the Computer Equipment cost is £50,000 (not £5,000) and depreciation is £40,000 (not £4,000). The value of retained earnings from prior years should be £4,650 in credit.

As with all of the entries made in QuickBooks, edits are easily made. There are many different ways to locate an entry. One of the simplest is to run the Trial Balance report for the desired period and click the balance against the account where the balances appear to be incorrect. That will list all of the transactions made to the account in the selected period. Click on the transaction that is incorrect, make the required edits, and save.

After correcting the journal for the value of assets, the opening balance equity now contains the value that should appear in retained earnings, so a simple journal will fix that.

Figure 1.21 – Final journal adjustment to correct balances

Figure 1.21 – Final journal adjustment to correct balances

After making our final adjustment, the Trial Balance report should be checked to ensure that all opening balances are correct to the last closed period. In this example, that's March 31, as we are starting using QuickBooks from April 1.

Figure 1.22 – Trial Balance report after the opening balances are completed

Figure 1.22 – Trial Balance report after the opening balances are completed

The opening balances are now complete. Once the opening balances have been fully agreed, it is a particularly good idea to close the books with a password, using the options within the Advanced tab of Account and settings.

Figure 1.23 – Set books as closed with a password

Figure 1.23 – Set books as closed with a password

Summary

This chapter has explained in detail how opening balances can be created when a company shifts to QuickBooks at any given point.

Here is a very brief recap:

  • Customer Balances: Create invoices/credit notes that mirror those that were unpaid in your old system prior to the switch to QuickBooks. Use a product/service for opening balances linked to the Opening Balance Equity account. If Cash Accounting for VAT, invoices should be entered net + VAT; otherwise, enter the invoices to reflect the total gross amounts due, ignoring VAT.
  • Supplier Balances: Create supplier bills/credits that mirror those that were unpaid in your old system prior to the switch to QuickBooks. The bills should be coded to the Opening Balance Equity account category, and if reporting VAT on a cash basis, values should be entered net + VAT.
  • Bank Accounts: Edit the chart of account code and enter a balance as at the last closed period (the day before QuickBooks was brought into use). Uncleared payments and deposits can be listed within a journal.
  • VAT/GST/Sales Tax: Entering customer invoices and supplier bills net + VAT will populate values within the VAT control account. Journals can be used to recreate VAT returns for prior periods and adjust the VAT control account.
  • Other Balance Sheet Accounts: Edit the balance against the chart of account code at a desired date or use journal entries to create the balances to the last closed period (the day before QuickBooks is brought into use).

With all of your opening balances in place, you should be all set. The following chapter includes some tips for general day-to-day use, as well as some additional settings you should check.

Furthermore, if you have made a complete mess setting up, it's possible to scrap all the data and start over, so we shall cover that too.

Tip

During each step of creating opening balances, it is a good idea to run various reports and compare them to the data that was held using previous accounting systems.

For example, running the Accounts payable ageing summary and Accounts receivable ageing summary reports is always a good place to start to ensure the opening balances for customers and suppliers are correct at the date QuickBooks Online was first put into use.

Left arrow icon Right arrow icon

Key benefits

  • Broaden your knowledge of QuickBooks Online and accounting concepts
  • Understand how QuickBooks can be adapted to suit different business types using professional techniques
  • Learn best practices for preparing annual accounts before closing the books for the year

Description

Accountants and bookkeepers can sometimes face challenges while coming up with solutions to help their clients. QuickBooks Online, a popular cloud accounting software, comes with a wide range of tools that can take time to learn. This book will show you how to properly combine the tools available in QuickBooks to get the most out of this software. Complete with step-by-step explanations of essential concepts and practical examples, the book will begin by helping you understand how to create opening balances for a new company. You'll then discover essential bookkeeping and accountancy tips and tricks, and find guidance to help make QuickBooks as easy to use as possible. As you advance, you'll explore different scenarios in which QuickBooks Online can be used for various business types. This will help you understand that not every business is the same, but using the wide range of functionalities QuickBooks Online offers, you can customize solutions to really make it work for you. By the end of this QuickBooks book, you'll have gained deep insights into how you can use QuickBooks Online to work for different business types, and you'll have a complete checklist of the different things you should be doing when you start reviewing accounts ahead of tax season.

Who is this book for?

Business owners, company directors, accountants, bookkeepers, certified public accountants (CPAs), and anyone studying accounting and bookkeeping will find this book useful. The book contains general bookkeeping and accountancy tips and is designed to help you get the most out of the tools available in QuickBooks Online. Prior QuickBooks knowledge is necessary.

What you will learn

  • Discover how to correctly set up QuickBooks Online with opening balances
  • Adapt QuickBooks Online to meet specific industry needs, from manufacturing and retail using inventory to helping lawyers and property agents handle client funds
  • Get the most out of features such as Projects and Multicurrency
  • Review reports within QuickBooks Online, understand why errors occur, and learn how to resolve them
  • Get to grips with key accounting principles and concepts tailored for bookkeeping and accounting beginners
  • Find out how the audit trail works and explore all of the information it holds
Estimated delivery fee Deliver to Slovenia

Premium delivery 7 - 10 business days

€25.95
(Includes tracking information)

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Dec 08, 2021
Length: 344 pages
Edition : 1st
Language : English
ISBN-13 : 9781801810371
Vendor :
Intuit
Tools :

What do you get with Print?

Product feature icon Instant access to your digital eBook copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Product feature icon AI Assistant (beta) to help accelerate your learning
OR
Modal Close icon
Payment Processing...
tick Completed

Shipping Address

Billing Address

Shipping Methods
Estimated delivery fee Deliver to Slovenia

Premium delivery 7 - 10 business days

€25.95
(Includes tracking information)

Product Details

Publication date : Dec 08, 2021
Length: 344 pages
Edition : 1st
Language : English
ISBN-13 : 9781801810371
Vendor :
Intuit
Tools :

Packt Subscriptions

See our plans and pricing
Modal Close icon
€18.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
€189.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts
€264.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total 78.97
Professional Tips and Workarounds for QuickBooks Online
€24.99
Mastering QuickBooks 2021
€26.99
Mastering Quickbooks® 2023, Fourth Edition
€26.99
Total 78.97 Stars icon
Banner background image

Table of Contents

15 Chapters
Section 1 – General Tips and Shortcuts Chevron down icon Chevron up icon
Chapter 1: Creating and Reviewing Opening Balances in QuickBooks Online Chevron down icon Chevron up icon
Chapter 2: Useful Tips and Tricks Every QuickBooks User Should Know Chevron down icon Chevron up icon
Section 2 – Adapting QuickBooks Online to Suit Different Business Types Chevron down icon Chevron up icon
Chapter 3: QuickBooks Online for Manufacturing Businesses Chevron down icon Chevron up icon
Chapter 4: Recording Income for Retail Businesses Chevron down icon Chevron up icon
Chapter 5: Handling Client Money Chevron down icon Chevron up icon
Chapter 6: The Secret to Success with Projects in QuickBooks Online Chevron down icon Chevron up icon
Chapter 7: Handling Foreign Currencies in QuickBooks Online Chevron down icon Chevron up icon
Section 3 – Reviewing and Reporting Data in QuickBooks Online Chevron down icon Chevron up icon
Chapter 8: Best Practices When Reviewing Financial Records Chevron down icon Chevron up icon
Chapter 9: Enhancing the Consistency of Your Financial Statements Chevron down icon Chevron up icon
Chapter 10: Reconciling the Balance Sheet Chevron down icon Chevron up icon
Chapter 11: Closing the Year-End, the Audit Log, and More Chevron down icon Chevron up icon
Other Books You May Enjoy Chevron down icon Chevron up icon

Customer reviews

Top Reviews
Rating distribution
Full star icon Full star icon Full star icon Full star icon Half star icon 4.5
(6 Ratings)
5 star 66.7%
4 star 16.7%
3 star 16.7%
2 star 0%
1 star 0%
Filter icon Filter
Top Reviews

Filter reviews by




Annette Pettitt Dec 21, 2021
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Useful tips for QuickBooks, easy to read, no confusing language. Really helping me solve problems as they arise! Definitely worth getting if you are a QuickBooks user.
Amazon Verified review Amazon
Mrs Sally Scott Jan 04, 2022
Full star icon Full star icon Full star icon Full star icon Full star icon 5
I saw this detailed on a Facebook feed and ordered ahead of release. It's an excellent book, so pleased I bought it. I had to set up multi currency and used this book on day one for help on how to action.
Amazon Verified review Amazon
Ashley Leeds Jan 20, 2022
Full star icon Full star icon Full star icon Full star icon Full star icon 5
What a fantastic resource!! Ashley has packed in most of his knowledge into this great book with loads of examples of exactly what you need to make your experience of QuickBooks Online better.It covers the basics but also goes into great detail in all the areas you or your clients will need.Easy to read and with all the screenshots you can easily get to the outcomes that you are looking for. If you want you can even download the colour images in pdf form from instructions in the book in the 'How to use this book' section.If you want to know more about how to use QuickBooks Online, then this book will be your personal guide.
Amazon Verified review Amazon
awright Jan 01, 2022
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Excellent practical resource. Takes the user from set up to tips and tricks on how to use the software efficiently. Someone having never used the software will be able to set up correctly with all the opening balances, file VAT returns and learn really practical tips on how to use the software. Ash comes with years of practical experience and this is displayed brilliantly in this book. Would recommend this resource for anyone wanting to get started with QuickBooks Online or someone with experience but wanting to learn more tips to make practical use of the software.
Amazon Verified review Amazon
Amazon Customer Jul 28, 2022
Full star icon Full star icon Full star icon Full star icon Empty star icon 4
This book covers a lot of the functionality of QBO - good reference for those new to using this software.
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

What is the delivery time and cost of print book? Chevron down icon Chevron up icon

Shipping Details

USA:

'

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


Unfortunately, due to several restrictions, we are unable to ship to the following countries:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela
What is custom duty/charge? Chevron down icon Chevron up icon

Customs duty are charges levied on goods when they cross international borders. It is a tax that is imposed on imported goods. These duties are charged by special authorities and bodies created by local governments and are meant to protect local industries, economies, and businesses.

Do I have to pay customs charges for the print book order? Chevron down icon Chevron up icon

The orders shipped to the countries that are listed under EU27 will not bear custom charges. They are paid by Packt as part of the order.

List of EU27 countries: www.gov.uk/eu-eea:

A custom duty or localized taxes may be applicable on the shipment and would be charged by the recipient country outside of the EU27 which should be paid by the customer and these duties are not included in the shipping charges been charged on the order.

How do I know my custom duty charges? Chevron down icon Chevron up icon

The amount of duty payable varies greatly depending on the imported goods, the country of origin and several other factors like the total invoice amount or dimensions like weight, and other such criteria applicable in your country.

For example:

  • If you live in Mexico, and the declared value of your ordered items is over $ 50, for you to receive a package, you will have to pay additional import tax of 19% which will be $ 9.50 to the courier service.
  • Whereas if you live in Turkey, and the declared value of your ordered items is over € 22, for you to receive a package, you will have to pay additional import tax of 18% which will be € 3.96 to the courier service.
How can I cancel my order? Chevron down icon Chevron up icon

Cancellation Policy for Published Printed Books:

You can cancel any order within 1 hour of placing the order. Simply contact customercare@packt.com with your order details or payment transaction id. If your order has already started the shipment process, we will do our best to stop it. However, if it is already on the way to you then when you receive it, you can contact us at customercare@packt.com using the returns and refund process.

Please understand that Packt Publishing cannot provide refunds or cancel any order except for the cases described in our Return Policy (i.e. Packt Publishing agrees to replace your printed book because it arrives damaged or material defect in book), Packt Publishing will not accept returns.

What is your returns and refunds policy? Chevron down icon Chevron up icon

Return Policy:

We want you to be happy with your purchase from Packtpub.com. We will not hassle you with returning print books to us. If the print book you receive from us is incorrect, damaged, doesn't work or is unacceptably late, please contact Customer Relations Team on customercare@packt.com with the order number and issue details as explained below:

  1. If you ordered (eBook, Video or Print Book) incorrectly or accidentally, please contact Customer Relations Team on customercare@packt.com within one hour of placing the order and we will replace/refund you the item cost.
  2. Sadly, if your eBook or Video file is faulty or a fault occurs during the eBook or Video being made available to you, i.e. during download then you should contact Customer Relations Team within 14 days of purchase on customercare@packt.com who will be able to resolve this issue for you.
  3. You will have a choice of replacement or refund of the problem items.(damaged, defective or incorrect)
  4. Once Customer Care Team confirms that you will be refunded, you should receive the refund within 10 to 12 working days.
  5. If you are only requesting a refund of one book from a multiple order, then we will refund you the appropriate single item.
  6. Where the items were shipped under a free shipping offer, there will be no shipping costs to refund.

On the off chance your printed book arrives damaged, with book material defect, contact our Customer Relation Team on customercare@packt.com within 14 days of receipt of the book with appropriate evidence of damage and we will work with you to secure a replacement copy, if necessary. Please note that each printed book you order from us is individually made by Packt's professional book-printing partner which is on a print-on-demand basis.

What tax is charged? Chevron down icon Chevron up icon

Currently, no tax is charged on the purchase of any print book (subject to change based on the laws and regulations). A localized VAT fee is charged only to our European and UK customers on eBooks, Video and subscriptions that they buy. GST is charged to Indian customers for eBooks and video purchases.

What payment methods can I use? Chevron down icon Chevron up icon

You can pay with the following card types:

  1. Visa Debit
  2. Visa Credit
  3. MasterCard
  4. PayPal
What is the delivery time and cost of print books? Chevron down icon Chevron up icon

Shipping Details

USA:

'

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


Unfortunately, due to several restrictions, we are unable to ship to the following countries:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela