General Ledger Data Can Be Reconstituted on QuickBooks 2022

Total Time: 6 minutes

1. Step One

   Open the exported data in Excel worksheet.

2. Step Two

   Now insert a new column under Accounts.

3. Step Three

   Once the column is added, under the ‘Account’ insert the formula =IF(Cell number of the parent company=””, Cell number where the formula is written, Cell number of the parent account company). By this formula, you would come to know about the parent company’s account name. If you leave this cell blank then it will take the account name from the previous row.

4. Step Four

   Now you need to copy the formula till the bottom of the column of your report. You can do so by copy pasting the formula or by selecting the cell where you have entered the formula and dragging the small square button down till the desired row and double clicking. This will copy the formula in all the cells of the column.

5. Step Five

   By doing so, you would notice that the name of Parent account of every row will appear under ‘Account’. Once this is confirmed, you need to add Subaccounts. To do so,

6. Step Six

   Type Subaccount in the cell which is next to ‘Account’. Now below the cell enter the formulae: IF(Right(number of cell that you want to check, 5)=”Other”,””,Number of cell that you want to check). This formula will check the last five letters of the cell which are ‘Other’ and if find it then the Value of that cell will be returned. It will ignore the parent account with the title of Other.

7. Step Seven

   Now you have to replace the formula with : IF(cell number that you want to check=””, cell number that contains formulae,IF(Right(Cell mumber that you want to check,5)=”Other”,””,Cell number that you want to check)). This will help assist you in filling the blank cells under Subaccounts with the name entered in the preceding cell.

8. Step Eight

   Now replace the earlier formula with : IF(Cell number that you want to check is blank or not<>””,””,IF(Cell number that you want to check=””,Cell number that contains the formulae,IF(Right(Cell number that you want to check,5)=”Other”,””,Cell number that you want to check))). Now you have to copy the formula till the bottom of the column using any one of the methods explained above. With this you would see the names of subaccount appearing in the column.

9. Step Nine

   This step involves creating one more heading other than Subaccount, and naming it as Joint. Below it enter: Name of the corresponding cell under account&IF(Corresponding cell in subaccount=””,””,”:”&Corresponding cell under subaccount).

10. Step Ten

    In this final step, you have to copy the column named ‘Joint’ and then paste it as value. Once done, combine the debit and credit money transactions into one. Now you will see that the General Ledger report has been reconstituted in Microsoft Excel as a worksheet file. Once this is done, you can easily delete any unnecessary column from the General Ledger report, and then analyse the data by creating a pivot table or any other method as per your requirement.