Merge two data sets using Excel

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.

Thank you!

Kemahiran: Perakaunan, Pemasukan Data, Excel

Lihat lagi: merge data sets excel, excel merge data sets, merge sets data excel, excel merge data sets excel, merge side side data excel, merge accounts freelancer, line sets data excel, excel data set merge, where to get data entry job, where get data entry job, t accounts in accounting, t accounts accounting, spreadsheet accounting, sorted data set, sorted data, lined in, lined, job matches, get experience in accounting, freelancer with excel, freelancer job side, freelancer in accounting, freelancer accounting job, data freelancer account, data entry job descriptions

Tentang Majikan:
( 7 ulasan ) SYDNEY, Australia

ID Projek: #1552989

Dianugerahkan kepada:


Hello Thanks you for considering me. I am new to Freelancer but have 10+ years with spreadsheets and manipulating data. This includes preparing, reconciling and confirming data extracted from accounting systems and le Lagi

$30 AUD dalam 2 hari
(3 Ulasan)

25 pekerja bebas membida secara purata $54 untuk pekerjaan ini


Expert here, please see the Pm for more details

$30 AUD dalam 0 hari
(72 Ulasan)

Mate, Excel VBA expert ready to start. Please check PM for details. Thanks!

$50 AUD dalam 3 hari
(59 Ulasan)

Please check PMB for details. Thank you

$40 AUD dalam sehari
(79 Ulasan)

Hi, i can do this for you, thanks

$50 AUD dalam 2 hari
(53 Ulasan)

Dear sir, Please check the pm

$30 AUD dalam sehari
(47 Ulasan)

Hi... I am a Certified Professional( Equivalent to CPA).

$30 AUD dalam sehari
(14 Ulasan)

I have just seen your Job posting and upon reading thoroughly, I felt strongly that I would be the most qualified contractor for your project. I have vast experience in IT/ Data Entry/ Web/ and Marketing. Understanding Lagi

$30 AUD dalam 7 hari
(11 Ulasan)

CPA (Auditor/Accountant),& MBA professional with High Honors award is here ready to work on this project for you in a very organized, efficient, & effective way. Very keen to details, expert in Accounting/Auditing fiel Lagi

$45 AUD dalam 2 hari
(21 Ulasan)

Please see what I said.

$30 AUD dalam 2 hari
(22 Ulasan)

Hi, I am expert in Excel, Please check your PM.

$40 AUD dalam sehari
(11 Ulasan)

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

$100 AUD dalam 3 hari
(6 Ulasan)

I have over 25 years of experience with excel spread sheets and I feel like I am a good fit for this project. I believe you will be pleased with the results of my work and my work ethic as well. Thank you for your co Lagi

$150 AUD dalam 15 hari
(1 Ulasan)

hi sir i am ready for work kindly check pm

$200 AUD dalam 20 hari
(3 Ulasan)

Hi I have the experience required for this job. You can my profile, I have detailed everything in it.

$30 AUD dalam 3 hari
(4 Ulasan)

Consider the job is done. read PM for more details

$50 AUD dalam 0 hari
(3 Ulasan)

Hello there gud day! My name is fred wenceslao and is based in the Philippines. To be frank and honest with you, i'm new here at free [login to view URL] and this is my firts time to participate in the bidding. Your p Lagi

$70 AUD dalam 12 hari
(0 Ulasan)

Interested in your project

$40 AUD dalam 2 hari
(0 Ulasan)

I'm familiar in excel spread sheet & I can do this.

$30 AUD dalam 2 hari
(0 Ulasan)

Sir, I will to do it! Thanks & best Regards Imran Farooq

$30 AUD dalam 0 hari
(0 Ulasan)

Hi, I am very much interested to do this project; becasue I have developed many General Ledger Accounting system. Please read PMB.

$70 AUD dalam 2 hari
(0 Ulasan)