176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Bank Reconciliation on Excel 2007
Sign in to Add to Watch List

Finance & Management > Accounting

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Jun 6, 2012
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Tue, Jun 05, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: $50 - $150
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

I want to use an excel workbook with 2 sheets as follows:

Sheet1:
Contain Book records of :Number, Source, Type, Date, Reference, Amount,Status
The info on this first sheet is to be compared to:

Sheet2,
Contains: Number, Source, Type, Date, Reference, Amount, Status

These are the headers for each sheet. The Book/Bank label only shows the source of the data (whether it came from the company Book or the Bank Statement). The Column with the header "Status" will be used to indicate if the item was determined as a CLEARED item (an EXACT match in both sheets) OR "N/A" IF THERE IS NO MATCH after comparing the 2 sheets...

Below these headers are data that need to be compared (ns comprising anywhere from 100 items to several hundreds.from 100 items to 2000)

I want you to create a Visual Basic Macro (for Excel 2007) that would perform a loop to COMPARE the information in BOOK tab against similar info on the BANK STATEMENT (This is a BANK RECONCILIATION).


The source column will indi...

Sign in or Register to see more

Desired Skills
Accounting
Job ID: 31007940
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 United States
Highly analytical and accomplished professional, interested in pursuing advancement to continue the promotion of skills, knowledge and leadership...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 31210623  |  Submitted: Jun 13, 2012 12:27 ET 
Proposal SEALED

 Philippines  |  
Job Description: Currently working at Cinderella Dresses as Accounting Manager
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 31208011  |  Submitted: Jun 13, 2012 10:44 ET 
Proposal SEALED

 Philippines  |  
To pursue and achieve part time position in your company where my abilities and skills will have valuable application to support your department...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 31145749  |  Submitted: Jun 11, 2012 06:38 ET 
Proposal SEALED

 India  |  
I am an accounting technician having more than 10 years experience in core accounting and Indian Taxation, well versed with accounting principles...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 31142378  |  Submitted: Jun 11, 2012 03:40 ET 
Proposal SEALED

 Pakistan  |  
I have done BBA and MBA(finance) and also have computer courses.
2
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 31139363  |  Submitted: Jun 11, 2012 01:07 ET 
Proposal SEALED

 India  |  
Being more exposed to accounts, audits and Finance I would like to provide services related to the same and would like to enhance my scope of...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 31136047  |  Submitted: Jun 10, 2012 19:40 ET 
Proposal SEALED

 United States  |  
FULL CHARGE BOOKEEPING, ACCOUNTS PAYABLE, ACCOUNTS RECEIVABLE, FINANCIAL STATEMENTS, BANK RECONCILIATIONS, GENERAL LEDGER AND ACOUNT...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 31132172  |  Submitted: Jun 10, 2012 13:20 ET 
Proposal SEALED

 India  |  
B Com graduate with over 20 years of rich and wide exposure in all aspects of accounts, finance, costing, accounts reconcilliation, Accounts...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 31131296  |  Submitted: Jun 10, 2012 12:04 ET 
Proposal SEALED

 United States  |  
I am looking for a freelancer jobs.
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 31115455  |  Submitted: Jun 9, 2012 08:07 ET 
Proposal SEALED

 India  |  
Since joining elance in 2012, I have worked for a number of clients, mainly from United States, United Kingdom and Australia. I am experienced and...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 31095437  |  Submitted: Jun 8, 2012 08:24 ET 
Proposal SEALED

Mujeeb Ahmed      
Mujeeb Ahmed's identity has been verified.  Learn More
 Pakistan  |  
I am an individual with over 5 years of experience in the field of Book keeping, Accounting, Taxation, Financial Management and Academic Writing. I...
2
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 31065142  |  Submitted: Jun 7, 2012 03:43 ET 
Proposal SEALED

 India  |  
I HAVE MORE THAN 17 YEARS OF WORKING EXPERIENCE IN FINANCE/ACCOUNTS/INTERNAL AUDITING. GOOD WORKING KNOWLEDGE IN ACCOUNTING, MS OFFICE SOFTWARES...
Skills: TALLY ERP, EXCEL
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 31047706  |  Submitted: Jun 6, 2012 11:54 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »