Convert QuickBooks Accountant Copy To Company File

by James Antonio

QuickBooks business files sometimes can become corrupted and there is no backup, but you have an Accountant’s Copy. QuickBooks may convert the Accountant’s Copy to a workable QuickBooks data file. However, any modifications you made to your company file after the Accountant’s Copy was prepared will have to be re-entered.

QuickBooks lets you convert your company’s working file to many types from a portable file, backup file to an accountant’s copy .QBA and .QBX to .QBW.

Save Time, Reduce Errors, and Improve Accuracy

Dancing Numbers helps small businesses, entrepreneurs, and CPAs to do smart transferring of data to and from QuickBooks Desktop. Utilize import, export, and delete services of Dancing Numbers software.

Today, in this blog we will show you a complete guide on how you can Convert QuickBooks Accountant Copy to Company File.

Converting Accountant’s Copy QuickBooks To Company File

Using QuickBooks Enterprise Accountant or Premier Accountant versions of QuickBooks desktop, QuickBooks helps you to effortlessly convert the file. This functionality is not available in other versions of the software. You will also be unable to generate an Accountant’s Changes file once the file has been converted to a business file. You Just have to re-enter any modifications you made to the original company file.

To convert your Accountant’s copy to a Company file, carefully follow the instructions outlined below:

Step 1: To Change your Accountant’s Copy to a Company File

  • First, Double-click your Accountant’s Copy (.QBA or QBX file) to open it.
  • Then, to save your data and prevent data loss, make a backup of the file before proceeding.
  • Now select Send Company File from the File menu.
  • Select Accountant’s Copy and then Convert Accountant’s Copy to Company File/QBW from the drop-down menu.
  • Once you convert your file then just confirm the procedure by clicking OK.
  • Now you will be prompted to select a location for the file to be saved.
  • Select a folder and rename the file according to your preferences.
  • After renaming the file, save your file.
  • Finally, press the OK button.
  • A new file will be created where you can work as a company file and you can make changes to it without any restrictions.

Step 2: To Change your Accountant’s Copy to a Normal File

  • First without having to establish an accountant file.
  • Start using QuickBooks Select Accountant’s Copy from the File menu.
  • Select Convert Accountant’s Copy to Company File from the drop-down menu.
  • Now, a new window will open after you select the convertor option.
  • Locate and open the Accountant’s Copy file you wish to convert.
  • On the screen, there will be a dialogue box that explains the procedure’s restrictions.
  • Then hit OK after rechecking the file you want to convert.
  • Once done choose a location where you wish to save the newly converted file and then rename the chosen file.
  • Now under the ‘Save as type option, select QBW as the file extension.
  • When you click Save, the file will be converted and you will be notified when it is finished.
  • Finally, click the OK button.
  • Now you will have an a .qbw file where you can work as a normal file.

Step 3: To Change Accountant’s Copy as Accountant’s Changes (.QBY)

  • First of all, navigate to the File menu in QuickBooks.
  • Now select Open and Restore Company from the drop-down menu.
  • Then choose the next option after selecting Convert an Accountant’s Copy Transfer File.
  • Once you select to convert the file, an overview of the file will be displayed.
  • Now after the file is opened that you have selected, click Next.
  • Then you will get an overview of your selected file, recheck the file.
  • Once you have rechecked the file, click Next.
  • Now locate and open the Accountant’s Copy file.
  • Once the accountant’s copy is opened, confirm the conversion and give the file a name.
  • Now, save the file.
  • You’ll have a functioning file (.qby) in which you can make changes without any restrictions.

Step 4: To Make Changes in Your Client’s Books

Your client’s information, including their lead accountant, is displayed in the client list. You’ll also be able to examine the current state of tasks such as tax preparation and returns QuickBooks can also help to make changes to your client’s books. You can do the following tasks using different Accountant Tools:

Account Balances Correction

This function shows the disparities in balances and offers how to rectify the opening balances by altering inputs.

There are no balances in Accountant’s Records for a previous review period when you use this function for the first time. When you finish the review after the first, the balances are preserved. You won’t have to manually input any balances after the second review. The remainder of the process is the same after the balances are entered, whether manually or automatically.

Prior Transactions Period Dates

In the fields at the top of the form, fill in the form and to dates, as well as the basis for the previous review period. The previous review period normally finishes one day before the next one begins. The review period however should not have the same length but the ending date should be current.

Enter or View Your Balances

The program will question you about copying the balances, and all you have to do is click Yes when the notification comes.

You may either input the balances manually or have the tool copy all of the balances from the Client’s File columns into the Balances in Accountant’s Records columns for the first review performed with this tool.

Consider the Differences

The sum of account-by-account variances between the Balances in Accountant’s Records and the Balances in Client’s File is revealed in the Difference columns in Client Data Review’s Troubleshoot Account Balances tool.

  • All transactions that are recorded in QuickBooks and Difference columns can be seen in Quick Zoom. All transactions by Account report for the specified account appears when you open the Quick Zoom.
  • The CDR Review list changes are displayed when you click the View List Changes button.
  • Check the “Just display accounts with different balances” box at the bottom of the window, or use the Alt-N shortcut to see only the accounts with discrepancies.
  • The Changed Transaction Report is accessed by clicking the View Changed Transactions button.

Inquire with your customer when the data input for the review period is finished.

  • On the Transaction Change Report, use one day after that date as the start date.
  • Today will always be the last date.

Check the Balance

  • The difference columns are computed every time you return to this feature during a review.
  • The difference column will be 0 when you fix the balances.
  • The presence of zero balances in the difference columns confirms that the review period’s opening balances are correct.

Correct the Balances

  • The difference columns no longer show a balance for that account if you’ve fixed any of the underlying transactions and the balances agree. You can construct an adjustment entry to rectify any leftover balances in the differences columns.
  • To see an adjusting entry with line items for each different column entry, select the View Suggested Adjustment button.
  • If there are balance disparities in both A/R and A/P, you must make numerous adjustment entries.
  • When you create an adjusting entry that affects part of the balances, the differences columns for the accounts affected by the entry are blank. For the remaining accounts, you can make another adjustment entry.

Written off Invoices

To write off a batch of bills, use the write-off invoices tool. For each invoice you write off, QuickBooks generates a credit memo. The invoice and credit memo both are created by QuickBooks to get a memo regarding the write-off.

Transactions are Entered in Batches

Use QuickBooks Desktop’s input batch transactions function to copy multiple transactions from one business file to another. This function can assist you in effectively saving and managing your time.

Batch transactions cannot be exported, but you may copy many transactions from one business file to another in a format that can be imported with the enter batch transactions function.

QuickBooks Desktop Accountant Edition Allows you to Remove or Invalidate Transactions in Bulk

QuickBooks also helps to swiftly remove or void several transactions at once, using the Batch Delete or Void Transactions program (BDT).

Delete or Invalidate Transactions Individually

  • Payments of Sales Tax.
  • Invoices that include billable time and expenses.
  • Any transaction that occurs within a time that has ended.
  • Paychecks.
  • Checks for Payroll Liability.
  • Reimbursed expenditures, hours, mileage, or items on invoices.
  • Paying Bills Online.

Note: To remove them one by one, open the transaction and choose Edit, then Delete.

Specific Transactions can be Deleted or Voided

  • Specific transaction types can be deleted or invalid. Select a transaction type from the Transaction Type menu.
  • You can delete or nullify these items from the list.
  • Bill payment checks, bill refunds, bill credits, refund checks, and financing charges are all included in the bills option.

Reclassify the Transactions of Your Clients

Make it simple for your customer to prepare their books for tax purposes. Use the Reclassify Transactions tool to locate and rectify transactions in your client’s books that have been assigned to the incorrect accounts or classes. You can reclassify transactions individually or in bulk.

Follow these instructions to do so:

  • Choose the fiscal year for which you wish to look at the data.
  • Examine the transactions.
  • Transfer transactions to a different category.

Changes to the List Should be Reviewed

The Review List Updates tool displays all changes to your lists, including the Chart of Accounts, Item List, Payroll Items, and Fixed Asset Items. You’ll be able to keep track of all the modifications you make to your lists this way. We’ll demonstrate how to use it and how to access it.

What all you have in Review List updates:

Change Other Name Types, Customers, and Vendors, and Review Item Setup

These drop-down menus open QuickBooks’ built-in functions. It allows you to review the things that need to be modified as well as those that have already been altered.

Items, Fixed Asset Items, and Payroll Items are all Part of the Chart of Accounts

You can examine and evaluate the modifications you’ve made to your products using these listings. When you open one of these, you’ll see the things that have been added, altered, removed, or merged.

Correct the Wrongly Recorded Sales Tax

When a customer pays sales tax with a standard check. You can convert all or a portion of your payments to sales tax checks at the same time. You can detect sales tax payments that were not recorded using the pay sales tax feature and fix this with the help of this tool.

To cancel the check and create a sales tax check, choose the Void and Replace option after you select all the transactions.

After you choose the Void and Replace, the following can happen:

  • The normal check’s reconciliation status, check number, date, and amount are all retained on the new Sales Tax Payable check.
  • Both checks contain a memo.
  • The ordinary check is invalidated, and a Sales Tax Payable check is substituted.

Inventory Troubleshooting

The Troubleshoot Inventory tool provides different perspectives on potential inventory issues. You can also select the best-presented items for your client’s firm by altering them and are in the inventory criteria. Once you check the inventory list, you may Quick Zoom to an inventory item to check up for any problems.

Configure the Display Dates

The review period is the default setting for the To and From dates. You are free to adjust the dates as needed and required. Once you change the date, use the tab key or click anywhere else on the screen to refresh it.

Modify the Displayed Objects

Inventory may be viewed in a variety of ways. After you’ve changed the view, click Refresh to see the inventory list with the modified criteria. To improve readability, the Type, Cost, Avg Cost, Sales Price, and percent Markup columns each have a separate backdrop color.

You must convert a QuickBooks Accountant’s Copy file before using it as a business file. It’s important to remember that the conversion procedure can only be completed using the versions of QuickBooks Desktop listed above. It is no longer possible to import an accountant’s modifications into a new .qbw file after an accountant’s copy has been converted to a .qbw file.

We hope now you have enough information about Convert QuickBooks Accountant Copy To Company File and hopefully the above-mentioned steps will help you to convert your QuickBooks Accountant Copy to Company file easily.

Accounting Professionals, CPA, Enterprises, Owners

Looking for a professional expert to get the right assistance for your problems? Here, we have a team of professional and experienced team members to fix your technical, functional, data transfer, installation, update, upgrade, or data migrations errors. We are here at Dancing Numbers available to assist you with all your queries. To fix these queries you can get in touch with us via a toll-free number 1800-689-5491 or chat with experts.


How do QuickBooks Help to Create a Write-off item?

To create a write-off, follow the steps mentioned below:

First, select Add New from the Write Off Item drop-down arrow.
Then leave Type to Other Charge in the New Item window.
Now enter a name for the item in the Item Name/Number box, such as “bad debt” or “write off”.
Once done leave the Amount or Percentage box blank.
The Tax Code field should be set to Tax. If the sale was previously nontaxable, don’t panic. Only taxable sales are reversed by QuickBooks.
Select the bad debt expenditure account from the Account drop-down arrow.
Finally, choose OK.

How to Use the Invoices to Be Written off Tool?

Follow the steps mentioned below to write off the invoices to Convert QuickBooks Accountant Copy To Company File:

First of all choose Accountant then go to Client Data Review.
Once done click on Client Data Review to open the Write Off Invoices window from the Client Data Review.
Now make a list of the bills you wish to write off and set criteria for them. Filter the list of open invoices using the fields at the top of the window.
Then select the bills to be written off in the checkbox column.
At the bottom of the window, choose the write-off item.
Finally, Change the Write Off Date if necessary.

How to use the Review List Updates tool to Convert QuickBooks Accountant Copy To Company File?

To use the Review List Updates tool to Convert QuickBooks Accountant Copy To Company File, Follow these steps:

First select Client Data Review from the Accountant menu.
Then go to the options Client Data Review and choose this option.
Then select the list you need to evaluate in the Review List Changes section.
For your checklist, you may alter the state of each list.
Not yet begun.
Work in Progress.
Completed.
This is not applicable.
Now examine the objects that have been added, altered, removed, or combined.
When you’ve finished reviewing all of the items, select Mark All as Reviewed.

Note: You won’t be able to modify the status of any goods after they’ve been marked as Reviewed.

How can you troubleshoot QuickBooks Inventories to Convert QuickBooks Accountant Copy To Company File?

To fix inventories to Convert QuickBooks Accountant Copy To Company File, follow these steps:

First, choose the Adjust Inventory Quantity at the bottom of the window.
Now you may change the amounts for all shown inventory items.
Then enter a new amount or the quantity difference for any of the items in the new window.
After you enter any of the details the other is automatically updated.
Now you must pick the Adjustment Account.
Once you select the adjustment account at the top of the list, you may enter a reference number, job, and class information.
When finished, choose Save and Close to save your changes and close the window.
Now to dismiss the window without making any changes, click Cancel.
Then you may receive cautions regarding the age of transactions after saving.

Note: If you did not enter a required Adjustment Account, you will receive a warning message and the changes are not processed.

Features of Dancing Numbers for QuickBooks Desktop

Imports

Imports

Exports

Exports

Deletes

Deletes

Customization

Customization

Supported Entities/Lists

Dancing Numbers supports all QuickBooks entities that are mentioned below:-

Customer Transactions

Invoice
Receive Payment
Estimate
Credit Memo/Return Receipt
Sales Receipt
Sales Order
Statement Charge

Vendor Transactions

Bill
Bill Payment
Purchase Order
Item Receipt
Vendor Credit

Banking Transactions

Check
Journal Entry
Deposit
Transfer Funds
Bank Statement
Credit Card Statement
Credit Card Charge
Credit Card Credit

Employee Transaction / List

Time Tracking
Employee Payroll
Wage Items

Others

Inventory Adjustment
Inventory Transfer
Vehicle Mileage

Technical Details

Easy Process

Bulk import, export, and deletion can be performed with simply one-click. A simplified process ensures that you will be able to focus on the core work.

Error Free

Worried about losing time with an error prone software? Our error free add-on enables you to focus on your work and boost productivity.

On-time Support

We provide round the clock technical assistance with an assurance of resolving any issues within minimum turnaround time.

Pricing

img

Importer, Exporter & Deleter

*See our Pricing for up to 3 Company Files

$199/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Unlimited Export
  • Unlimited Import
  • Unlimited Delete

img

Accountant Basic

*See our Pricing for up to 10 Company Files.

$499/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer,Exporter,Deleter
  • Unlimited Users
  • Unlimited Records
  • Upto 10 companies

img

Accountant Pro

*See our Pricing for up to 20 Company Files.

$899/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer, Exporter, Deleter
  • Unlimited Users
  • Unlimited Records
  • Up to 20 companies

img

Accountant Premium

*See our Pricing for up to 50 Company Files.

$1999/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer, Exporter, Deleter
  • Unlimited Users
  • Unlimited Records
  • Up to 50 companies

Frequently Asked Questions

 
How and What all can I Export in Dancing Numbers?

You need to click "Start" to Export data From QuickBooks Desktop using Dancing Numbers, and In the export process, you need to select the type you want to export, like lists, transactions, etc. After that, apply the filters, select the fields, and then do the export.

You can export a Chart of Accounts, Customers, Items, and all the available transactions from QuickBooks Desktop.


How can I Import in Dancing Numbers?

To use the service, you have to open both the software QuickBooks and Dancing Numbers on your system. To import the data, you have to update the Dancing Numbers file and then map the fields and import it.


How can I Delete in Dancing Numbers?

In the Delete process, select the file, lists, or transactions you want to delete, then apply the filters on the file and then click on the Delete option.


How can I import Credit Card charges into QuickBooks Desktop?

First of all, Click the Import (Start) available on the Home Screen. For selecting the file, click on "select your file," Alternatively, you can also click "Browse file" to browse and choose the desired file. You can also click on the "View sample file" to go to the Dancing Numbers sample file. Then, set up the mapping of the file column related to QuickBooks fields. To review your file data on the preview screen, just click on "next," which shows your file data.


Which file types are supported by Dancing Numbers?

XLS, XLXS, etc., are supported file formats by Dancing Numbers.


What is the pricing range of the Dancing Numbers subscription Plan?

Dancing Numbers offers four varieties of plans. The most popular one is the basic plan and the Accountant basic, the Accountant pro, and Accountant Premium.


How can I contact the customer service of Dancing Numbers if any issue arises after purchasing?

We provide you support through different channels (Email/Chat/Phone) for your issues, doubts, and queries. We are always available to resolve your issues related to Sales, Technical Queries/Issues, and ON boarding questions in real-time. You can even get the benefits of anytime availability of Premium support for all your issues.


How can I Import Price Level List into QuickBooks Desktop through Dancing Numbers?

First, click the import button on the Home Screen. Then click "Select your file" from your system. Next, set up the mapping of the file column related to the QuickBooks field. Dancing Numbers template file does this automatically; you just need to download the Dancing Number Template file.

To review your file data on the preview screen, just click on "next," which shows your file data.


What are some of the features of Dancing Numbers to be used for QuickBooks Desktop?

Dancing Numbers is SaaS-based software that is easy to integrate with any QuickBooks account. With the help of this software, you can import, export, as well as erase lists and transactions from the Company files. Also, you can simplify and automate the process using Dancing Numbers which will help in saving time and increasing efficiency and productivity. Just fill in the data in the relevant fields and apply the appropriate features and it’s done.

Furthermore, using Dancing Numbers saves a lot of your time and money which you can otherwise invest in the growth and expansion of your business. It is free from any human errors, works automatically, and has a brilliant user-friendly interface and a lot more.


Why should do you change the Employee status instead of deleting them on QuickBooks?

If you are unable to see the option to terminate an employee on your list of active employees on the company payroll, this mostly implies that they have some history. Thus, if you change the employee status instead of deleting it on QuickBooks, the profile and pay records remain in your accounting database without any data loss in your tax payments.


Is it possible to use the Direct Connect option to sync bank transactions and other such details between Bank of America and QuickBooks?

Yes, absolutely. You can use the Direct Connect Option by enrolling for the Direct Connect service which will allow you access to the small business online banking option at bankofamerica.com. This feature allows you to share bills, payments, information, and much more.


Why should do you change the Employee status instead of deleting them on QuickBooks?

If you are unable to see the option to terminate an employee on your list of active employees on the company payroll, this mostly implies that they have some history. Thus, if you change the employee status instead of deleting it on QuickBooks, the profile and pay records remain in your accounting database without any data loss in your tax payments.


What are the various kinds of accounts you could access in QuickBooks?

QuickBooks allows you to access almost all types of accounts, including but not limited to savings account, checking account, credit card accounts, and money market accounts.

Get Support

Bulk import, export, and deletion can be performed with simply one-click. A simplified process ensures that you will be able to focus on the core work.

Worried about losing time with an error prone software? Our error free add-on enables you to focus on your work and boost productivity.

Call Now +1-800-689-5491
Dancing Number

Kindly Provide The Following Information To Download The Dancing Numbers.

X





    Top