QuickBooks is one of the best accounting software out there with over 10 million user. The impressive UI and the ability to connect with online services makes it even more powerful.

Intuit is more concerned in moving its desktop users to the QuickBooks online version. In Spite of the fact that both the desktop and online versions of QuickBooks are not similar and QuickBooks online lacks a number of desired feature. If you are a QuickBooks Enterprise customer you will surely be disappointed with the online version.

Advanced QuickBooks Services was incorporated to provide priority services to the customers who are always putting in efforts to maximize business gains and have no extra time for conventional QuickBooks support system.

Advanced QuickBooks Services provide QuickBooks data recovery and company file repair services. We are heros in troubleshooting QuickBooks errors and our priority turnaround time is 24 hours guaranteed.

So, if you are looking for urgent help with your QuickBooks software look no further and call our emergency support team at +1-800-910-6880 and let us know.

QuickBooks, Enterprise Solutions & Point of Sale Services

Advanced QuickBooks Services supports Intuit QuickBooks, Enterprise Solutions and Point of Sale accounting software. We are focused on assisting business in using Intuit accounting software properly and providing solutions to QuickBooks & Point of Sale problems. We also help business get the most out of their accounting systems with data transfer services, reporting & report development and software integration services.

Advanced QuickBooks services caters to the small business person handling their own accounting, businesses with in house accounting functions and accounting professionals that may need assistance with QuickBooks and Point of Sale issues. We specialize in QuickBooks and Point of Sale services that are not commonly provided by other accounting professionals. Our only business is supporting Intuit accounting software users.

QuickBooks, Enterprise solutions & Point of Sale services offered

  1. Troubleshooting and file clean up services using a methodical & cost effective approach.
  2. Data transfer services.
  3. QuickBooks (desktop and online) set up services.
  4. Enterprise Solutions set up services.
  5. Point of Sale set up services with QuickBooks integration.
  6. QuickBooks Accounting help.
  7. QuickBooks Training & Support services.
  8. QuickBooks Reporting & Advanced Reporting services.
  9. QuickBooks Software integration.

Local Service- Middle Tennessee, Northern Alabama and N.W. Georgia

We are located near the town of Wartrace, Tennessee which is halfway between Nashville and Chattanooga. Onsite services are available in middle Tennessee, Northern Alabama and North West Georgia. We understand business isn’t 9 to 5 for most small business owners and we have extended business hours including weekends to accommodate your schedule.

Nationwide services

Advanced QuickBooks Services offers services nationwide using proven remote access tools and secure data file transfer services. Data security is an important concern and our security procedures protect client files. We conduct no business through our website, all file transfers are through secure file transfer services and payments are made through the Intuit payment network to protect your credit card information.

Blog posting

A “Tips and Tricks” Blog is included in this website and as time goes on I will be adding content. If you have any questions you would like answered please use the contact form and an answer will be provided as soon as possible. Go ahead and send some tough ones, I like a challenge. I will also be adding selected questions I have seen in my user groups that may be useful to others.


Nationwide services, Tennessee, Middle Tennessee, TN, Ashland City, Brentwood, Carthage, Chattanooga, Columbia, Cookeville, Cowan, Eagleville, Fayetteville, Franklin, Gallatin, Goodlettsville, Hendersonville, Jasper, LaVergne, Lawrenceburg, Lebanon, Lewisburg, Manchester, McMinnville, Morrison, Mount Juliet, Murfreesboro, Nashville, Pulaski, Shelbyville, Signal Mountain, Smithville, Smyrna, South Pittsburg, Sparta, Spring Hill, Tullahoma, Winchester, Woodbury

Customer Deposits in QuickBooks

How do I record customer deposits on invoices or sales receipts? A deposit is not revenue (yet) and needs to be recorded as a liability until such time the sale is made and the deposit can be applied. QuickBooks makes it easy to accept and track customer deposits.

1) Create an “other current liability” account in your chart of accounts named “Customer deposits”.
2) Create a new “service” item in your item list named “customer deposits” , make sure it is marked “non taxable” and the “rate” is left at “0.00″. The account will be the newly created “customer deposits” account from step one.
3) When accepting a deposit you will use the deposit item on your invoice or sales receipt. The process is like any other sales transaction other than the fact the liability account is affected rather than an income account. Cash is debited and the liability account is credited.
4) When the sale for which you accepted the deposit is made you will include this deposit item on the first empty line below the items on the sales receipt/invoice as a NEGATIVE number. This will reduce the amount owed by the deposit amount. The transaction will debit the “Customer deposits” account and credit your income account.

You will probably want reporting on customer deposits and that is a very simple task as well. Go to your reports menu and select “custom reports” then “transaction detail report”. Make sure you select “all” from the date field and select the following columns; Type, date, Source name, Amount, and Balance. In the “Total by” field you will want to select “customer”. Go to the filters tab and select “Item” and in the drop down list select “Customer deposits”. Click “OK” and you will have your customer deposit report. I would recommend that you change the header to something like “Customer Deposits” and then memorize the report for future use.

Missing Customer and Vendor Lists

You KNOW the Customer or Vendor was entered in your QuickBooks file but now they are no longer appearing in the lists. How do you restore the list?

Go to your “write checks” window and select the “payee field”. When you have opened the list of Payees hit CTRL + L and the name list will open. In the lower left hand side of the screen you will see “Name” which is a drop down list. Click on “resort list” and see if that resolves your problem.

If the resort list did not work it is time to get serious. Create and restore a portable company file. It is important to understand the portable file before taking this step, a portable file only includes the financial records of your company file. See this Intuit support page for more information – Support

If your portable file is also missing customer and vendor names please visit this Intuit support page for further help- support

Create a QuickBooks Practice File

QuickBooks has included “sample company files” which are useful when first learning QuickBooks however they are not as detailed as they could be and surprisingly enough have minor set up flaws. The sample files are great for getting your feet wet in QuickBooks however none of them will even be close to your own company file.

A copy of your company working (.QBW) file can be useful when you are training a new QuickBooks user or new hire in your accounting procedures. Another reason may be to test planned corrections or new procedures without risking your working file. Any time you want to “test or train” use a QuickBooks practice file.

It is very simple to make a practice copy of QuickBooks but take care to name it something very unique; it is possible to start entering day to day accounting data in the practice file without realizing it.

First close your QuickBooks program then navigate to your company file location. Most company files are located in the “Public” folder in windows. The “Public documents folder” contains an “Intuit file folder”. Open the Intuit file folder and you will see a “QuickBooks” folder which contains a “Company files “folder.

You will see your company file “Your company .QBW” Right click the file and copy it to the location of your choice. Once the file is copied to its new location change the name of the file by right clicking the file and editing the name. I suggest using Practice file and the month so there is no way to confuse it with your working file.

Once you have renamed the file double click it to open. You will see your regular company name in the upper left of the window in QuickBooks. In order to avoid confusion go to the company dropdown menu>company information and change the company name to PRACTICE. This will change the name in the QuickBooks window. You can now use the file for practice purposes.

Cash drawer payouts for Point of Sale and Cash Registers

QuickBooks Point of Sale has automated the cash payout for business expenses and is very easy to use. You can set a “default account” to post expenses to if desired by going to the Company preferences> Financial > Accounts > advanced and specifying the account you want to use. You are not limited to this account as the payout window has a drop down box to assign an expense account in QuickBooks.

To use the payout feature you select the “Point of Sale” drop down menu and select “new Payout” which opens the payout window. You enter the cashier name, the amount, the expense account in QuickBooks to use and any comments.

The payout will be reflected on the Z out report and will be recorded in QuickBooks during the financial exchange.

Cash Register

How do you handle petty cash payouts from your cash register in QuickBooks? In a small retail environment you may pay business expenses from your register on occasion. While this is not the preferred method of paying business expenses it is expedient when you need to pay someone quickly. It happens so let’s discuss how to do it,

You should have a “Cash in drawer” bank account set up in your QuickBooks accounting software. This is the amount you maintain in your register for making change.

When you need to disburse cash for a business expense from the cash drawer it is necessary to record that expense in your accounting records. The best way to handle recording the expense is to write a check against the cash drawer bank account.

Here is the simple way to do it.

  • Pay the vendor out of the cash drawer and retain the receipt in your register.
  • When you are filling out your daily summary sales receipt in QUickBooks at the end of the day you will include the receipt as part of your “cash payment to deposit”. An example is if you took in 500 dollars in cash but paid your window washer 20 dollars out of the register. You would only have 480 dollars in cash to deposit plus the receipt for 20 dollars. You record the full 500 dollars. (we will account for the 20 dollars in a later step)
  • Go to your “write checks” window and select the “cash in drawer” bank account. Make sure you select EFT in the check number since you will not be writing an actual check. Enter the amount of the expense paid out of the “cash drawer account” which is 20 dollars and code it to the proper expense account. Save and close as normal. This check will “remove” 20 dollars from the “cash in drawer account” and record the expense.
  • When you go to the “make deposits” window for that days sales you will see the full 500 dollars from your daily summary sales receipt ready to be deposited but you only have 480 actual dollars. To move the money back into the “Cash in drawer” account you simply select your “Cash in drawer” account in the “Cash back goes to” drop down box and record the 20 dollars. This adjusts the actual deposit to 480 dollars which is the amount of money you have in your hands.

What not to do

There is a procedure that while perfectly acceptable is not a great habit to develop. You could enter the expense directly on your deposit slip as a negative amount to the deposit and code it to the correct vendor and expense account. The problem is in your expense account reports the payment will show as a “deposit” rather than a check. You will also clutter up your deposits with expenses which I personally do not advocate. The main reason I discourage this practice is that once someone gets comfortable entering one type of transaction on a deposit slip they might get “creative” and enter other transactions that aren’t acceptable.

I hope this helps.