Combine and Consolidate

%3CLINGO-SUB%20id%3D%22lingo-sub-1881318%22%20slang%3D%22en-US%22%3ECombine%20and%20Consolidate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1881318%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20client%20exported%20monthly%20profit%20and%20loss%20statements%20from%20Quickbooks%20into%20separate%20worksheets.%20I%20am%20trying%20to%20find%20an%20easier%20way%20to%20combine%20the%20monthly%20data.%20The%20categories%20are%20not%20identical%20month%20over%20month.%20Some%20months%20might%20have%20additional%20or%20fewer%20income%2Fexpense%20categories.%20Is%20there%20a%20way%20to%20avoid%20manually%20combining%20this%20information%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1881318%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1881768%22%20slang%3D%22en-US%22%3ERe%3A%20Combine%20and%20Consolidate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1881768%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F866992%22%20target%3D%22_blank%22%3E%40rose_renteria%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3EI%20can't%20address%20the%20matter%20of%20exports%20from%20Quickbooks%2C%20whether%20or%20not%20there%20might%20be%20ways%20other%20than%20monthly%20to%20export%20that%20data.%3C%2FLI%3E%3CLI%3EI%20will%20say%20(as%20one%20who%20exports%20and%20then%20imports%20into%20Excel%20from%20four%20credit%20card%20accounts%20and%20three%20bank%20accounts)%20that%20it%20is%20most%20likely%20a%20serious%20mistake%20to%20import%20into%20separate%20monthly%26nbsp%3B%20sheets.%20My%20own%20multiple%20exports%20all%20are%20brought%20into%20the%20same%20growing%20database%2C%20now%20incorporating%20two%20years%20worth%20of%20individual%20transactions.%26nbsp%3B%3C%2FLI%3E%3CLI%3EThe%20way%20I've%20designed%20mine%2C%20I%20can%20categorize%20any%20given%20transaction%20line%20into%20a%20primary%20income%2Fexpense%20category%2C%20then%20a%20sub-category%20and%2C%20if%20needed%2C%20a%20sub-sub%20category.%20If%20something%20comes%20along%20that%20needs%20a%20new%20category%2C%20that%20can%20be%20added.%20It%20matters%20not%20a%20whit%20whether%20each%20category%20is%20present%20each%20month.%3C%2FLI%3E%3CLI%3EFinally%2C%20I%20use%20Excel's%20incredible%20Pivot%20Table%20capability%20to%20summarize%20the%20data%20monthly%2C%20and%26nbsp%3B%20(again%2C%20via%20%22natural%22%20Pivot%20Table%20capabilities)%20I%20can%20easily%20drill%20down%20on%20any%20given%20summary%20number%20in%20any%20given%20month%20to%20see%20the%20details%20of%20what%20transactions%20are%20present.%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20of%20which%20is%20to%20say%2C%20your%20question%20doesn't%20give%20an%20idea%20of%20how%20this%20workbook%20is%20structured%2C%20how%20you%20account%20for%20income%2Fexpense%20categories%20in%20the%20first%20place.%20Is%20it%20possible%20for%20you%20to%20post%20a%20sanitized%20(no%20confidential%20info)%20version%20of%20what%20you're%20working%20with%3F%20Without%20that%2C%20we%20can%20only%20give%20generalized%20advice.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

My client exported monthly profit and loss statements from Quickbooks into separate worksheets. I am trying to find an easier way to combine the monthly data. The categories are not identical month over month. Some months might have additional or fewer income/expense categories. Is there a way to avoid manually combining this information?

1 Reply

@rose_renteria 

 

  1. I can't address the matter of exports from Quickbooks, whether or not there might be ways other than monthly to export that data.
  2. I will say (as one who exports and then imports into Excel from four credit card accounts and three bank accounts) that it is most likely a serious mistake to import into separate monthly  sheets. My own multiple exports all are brought into the same growing database, now incorporating two years worth of individual transactions. 
  3. The way I've designed mine, I can categorize any given transaction line into a primary income/expense category, then a sub-category and, if needed, a sub-sub category. If something comes along that needs a new category, that can be added. It matters not a whit whether each category is present each month.
  4. Finally, I use Excel's incredible Pivot Table capability to summarize the data monthly, and  (again, via "natural" Pivot Table capabilities) I can easily drill down on any given summary number in any given month to see the details of what transactions are present.

 

All of which is to say, your question doesn't give an idea of how this workbook is structured, how you account for income/expense categories in the first place. Is it possible for you to post a sanitized (no confidential info) version of what you're working with? Without that, we can only give generalized advice.