Two sets of accounting data need to be lined up. The chosen freelancer will receive a spreadsheet in which the two data sets are side-by-side and have been partly lined up. The sets are already sorted by Date and Transaction Number.
They need to be lined up by amount.
The idea is, Set A has details we need but it doesn't have the account (GL) numbers; Set B has the account numbers. We need to ensure that each row in Set A gets the correct account number against it.
Some rows line up easily ie there is one row in Set A where the amount matches the amount in one row in Set B.
In many cases two or more rows in Set A add to the total of a row in Set B.
The idea is to identify the rows which add up to the row in Set B, group them together with the Set B row first, then copy down the account number and name to those rows.
The first 918 rows have been completed - there are 2622 rows in the spreadsheet so there are another 1704 rows to do.
This project requires great attention to detail and accuracy. It also requires understanding of accounting, particularly GL accounts. The person will need to have a good look at the data and work out from descriptions and amounts which rows get which account numbers.
If you are interested in this project, please indicate clearly your experience with Excel and accounting and let me know specifically about any job you have previously done which is similar.
25 pekerja bebas membida secara purata $54 untuk pekerjaan ini
Dear Buyer Thank you very much for giving us an opportunity to bid for your project. I am really interested in this project. I can start work on immediately. Please check PM. Thanks SHAN