Tax Trial Balance

Document Sample
Tax Trial Balance Powered By Docstoc

    Exporting Trial Balance Data From QuickBooks
1. Open the company in QuickBooks that you would like to import into Engagement.

2. Select Reports under the Navigators window.

3. On the Drop Down for Select a type of report select Accountant & Taxes, select Trial
   Balance as the selected report and then select Display.
4. Once you see your Trial Balance, select the Excel button.

           **Note: If you do not have account numbers assigned to your account
           description, as shown below, you must have QuickBooks assign them before
           you export the Trial Balance into Excel. To do this select Edit/Preferences
           from the menu bar. In the Preferences window, select Accounting from the
           list and check “Use account numbers”.

5. On the Export Report to Excel window, select either Send report to a new Excel
   spreadsheet or Send report to an existing Excel spreadsheet and then select
   OK. If exporting to an existing Excel spreadsheet, you will have to browse to that
   spreadsheet location in order to select it. After the export, Excel will automatically
   open to your imported Trial Balance.

   Once you have the Trial Balance in Excel, you will have to prepare the data for the
   import into your ProSystem fx Engagement Trial Balance. To do this, follow these
1. Insert a column between the Account Description column and the Debit column in
   your Excel Trial Balance. In order to do this, you will need to highlight column C,
   right click and select Insert.

2. Next, highlight column B. On the menu bar, go to Data/Text to Columns. The
   Convert Text to Columns Wizard Step 1 of 3 window will appear. Select Fixed Width
   and then select Next. Then, on step 2 of 3, verify that your column breaks are in the
   correct place and select Next again.

3. On the Convert Text to Columns Wizard – Step 3 of 3, highlight the column that is shown
   below and select Do not import column (skip) from the Column data format box
   on the upper left corner of the screen.

4. Next, combine your Debits and Credits into one column. To do this, you will need
   to subtract column F from column D. You can do this by typing =D3-F3 in cell G3
   and then drag the formula down to the bottom of the Trial Balance.

   To drag the formula down, put your curser over the square in the lower right corner
   of your cell. Once your curser appears as a solid black plus sign (+), hold down the
   left mouse button and drag the formula to the last row of your Trial Balance.

5. Next, you need to remove the formula from column G. To do this, perform the
   following steps:

          Highlight the entire column G, right click and select Copy.

Then, highlight the entire column G again and select Paste Special. On the
Paste Special window, select Values. This will remove the formulas from the
balance cells. To verify the formulas have been removed, highlight a cell in
column G and make certain there is a number rather than a formula in the Excel
formula bar.

6. Next, remove the columns that will not import. To do this, highlight columns D, E
   and F, right click and select Delete.

7. Finally, scroll through your chart of accounts and check account numbers for
   duplicated accounts and account descriptions for invalid characters.

   The following characters are invalid for account descriptions: ' | : " ·

   Your Trial Balance data is now ready to import into ProSystem fx Engagement.


Shared By:
Description: Tax Trial Balance document sample