Formatting Excel tables and creating excel sheet for accounting
Budget: $30 – $250 CAD
I downloaded PDF bank statements and then converted it to Excel. Some of the columns are not totally in line with each so looking to get some of them merged to clean up the sheet. All i need for this is to have some of the basic Columns done that can be added easily to the excel sheet I'm looking to get made.
One of the years after conversion were made into many different tables, needing to get 4 years worth completed.
I am also looking for a excel sheet to be created . The sheet would have Date, description , debit, credit and also have a broken down for many other columns for accounting. The thing that makes it challenging for me is I would like to look at the description and in the cell beside it type a word that it associated to which would then copy over the debit amount associated with the use and populate that number associated with the it. I have given an example.
One of the years after conversion were made into many different tables, needing to get 4 years worth completed.
I am also looking for a excel sheet to be created . The sheet would have Date, description , debit, credit and also have a broken down for many other columns for accounting. The thing that makes it challenging for me is I would like to look at the description and in the cell beside it type a word that it associated to which would then copy over the debit amount associated with the use and populate that number associated with the it. I have given an example.