Importing QuickBooks Pro Account Balances

Pro Account Balances
Pro Account Balances

You can utilize the QuickBooks Pro Account Balances import order to recover the record adjustments for your customer dependent on determined date ranges. Since QuickBooks Pro doesn’t store the starting adjustments, you have to import the earlier year’s closure adjustments from QuickBooks Pro. Complete the means in every one of the accompanying segments to build up the earlier year adjustments for your customer. 


A. Steps in Quickbooks Pro 

  • Pick Reports > Accountant and Taxes > Trial Balance. 
  • Select Last Fiscal Year from the Dates field. 
  • Snap the Export button on the toolbar, pick the new Excel exercise manual in the Export Report exchange, and snap the Export button. 

What is QuickBooks journal Entry.

B. Steps in Microsoft Excel 

  • After you have finished the means in the segment over, the worksheet will open in Excel consequently. 
  • Feature the primary segment to one side of the record number/depiction segment and supplement two new (clear) segments to fill in as the “goal” sections for the subsequent stage. 
  • To isolate the substance of the single record number-in addition to depiction segment into two sections, feature the primary segment and pick Data > Text to Columns. Pick the Fixed Width alternative and snap Next. Characterize where the two sections should begin and stop and afterward click Finish. 
  • Survey each line to recognize optional records and erase the essential records (if suitable for the customer) yet leave the auxiliary records in the spreadsheet. For any records that contain sub-account digits, you have to physically alter both the record number and portrayal to address them. 
  • Model: If the record section contains account number “4000” and the depiction segment says “Expenses Collected:4000.7 Dental Exam/Consultation,” change the record number to 4000.7 and address the portrayal to peruse “Charges Collected: Dental Exam/Consultation. 
  • Include another segment for the record type and label each record as A (for Asset), L (for Liability or Equity), R (for Revenue), or E (for Expense). 
  • Check that the Excel record contains segments for account number, depiction, type, and parity sums. Erase any unneeded sections. 
  • Spare your progressions to the Excel record. 

C. Steps in CSA (Trial Balance CS or Accountant’s Assistant) 

  • For a current CSA customer, pick File > Select Period to Process to move the period back to the earlier year. 
  • For another customer, you can make the customer in the earlier year. (For instance, on the off chance that the current year is 2008, at that point the customer would be made in 2007.) 
  • Pick Utilities > Import > Spreadsheet and afterward reorder the fitting gathering of cells from the Excel spreadsheet you arranged in the past area. Alter every section title to determine the information remembered for that segment (Account Number, Description, Type, Period Balance – Debit, and Period Balance – Credit) and indicate the fitting year-end date for each equalization. 
  • Note: Ending adjusts can be entered in the Trial Balance network for new Trial Balance CS customers just in the most recent time frame. 
  • At the point when the import is finished, pick File > Select Period to Process and snap the Close to Next Year catch to move the customer to the current year. 
  • Snap Yes when incited during the year-end near convey forward the monetary record account adjusts. 
  • To import the customer’s current-year balance sums for a Trial Balance CS customer, pick Utilities > Import > QuickBooks Pro Account Balances. 
  • Or on the other hand, in the event that you are an authorized client of Accountant’s Assistant, pick Utilities > Accountant’s Assistant > QuickBooks Pro – Account Balances Only.


Please enter your comment!
Please enter your name here