В роботі

Analyze a list of revenue items and compare to a GL listing to determine where the discrepancies are and why the totals differ

I have an excel spreadsheet detailing all the revenue booked into Quickbooks. I also have an excel spreadsheet detailing division reports for the year. The total revenues from the two sheets are different and I need to know where the difference is and why.

There are 62 transactions in one spreadsheet and 39 statements summarized in the other. The statements may contain revenue from one or more of the revenue transactions summarized.

I need supporting documentation showing the reconciliation between the two sheets with noted errors or explanations.

the same exercise has to be done for two sets of sheets not just one.

I have summarized the data into pivot tables already.

More detail on the project
Must prepare a report showing the reconciling of two lists of financial data. I need more than just pointing out which lines do not match but determining which lines may match a second set of data if they are combined. For example, revenue for a division may be $10,500 made up of 3 invoices on another sheet say $1,500, $5,000 and $4,000 that are separate due to timing issues. I have good data to start with and just need to see where the actual discrepancies exist with a report to show the reconciliation. Please let me know how you would approach the problem, what the timeline would be and whether you have the background to do this. I am happy to answer any questions should you need clarification.

Навички: Бухгалтерія, Бухгалтерія, Excel

Показати більше: oscommerce product listing grid list layout, fortune 1000 list revenue, local listing bookmarking list, auto post real estate listing craig list, post multiple listing craigs list, add listing craigs list, nationwide listing craigs list, list last items viewed website php, wish list add items different websites, can list 100 items day ebay, start listing craigs list, multiple listing craig list, post listing craigs list, need someone list ebay items, making listing craigs list

Про роботодавця:
( 3 відгуки(-ів) ) Calgary, Canada

ID проекту: #11792931

Доручено:

Ashishpaliwall

Greetings of the day! I would love to assist you in the project. I have been working on excel for last 3 years now automating an excel sheet is my everyday task. I can assure you the best quality work. Would love to Більше

$45 CAD за 2 дні(-в)
(12 відгуків(-и))
3.6

13 фрілансерів(-а) подали заявки на цю роботу; середня заявка - $47

elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega Більше

$50 CAD за 2 дні(-в)
(170 відгуків(-и))
6.7
atalr42743

Hi! I can help you in identifying the reason for the difference and will make a reconciliation sheet as well. Let me know if my services could be of use to you. Thanks, Atal

$40 CAD за 1 день
(28 відгуків(-и))
6.5
cuongtn

Hi, I am ACCA member with 5 year experience in accounting. I am able to do your task. Please send detail your document Thank you.

$50 CAD за 3 дні(-в)
(262 відгуків(-и))
6.4
wsh2

At your earliest convenience, could you please attach a copy of your workbook(s) to a private chat message so we may better discuss your requirement. Thank you in advance! Greetings from the USA.. {smile} Highly Більше

$88 CAD за 1 день
(29 відгуків(-и))
5.8
kanchana1974

Hi, I am a Finance & Accounting Professional with MBA Finance, CMA qualification and have experience in Accounting & Book keeping functions. I have knowledge & working experience in P&L statements, MS Excel an Більше

$100 CAD за 3 дні(-в)
(46 відгуків(-и))
5.6
RRconsultant

Hi there, I am keen to help you on the project. I possess the necessary skills and expertise to complete this. Look forward to hear back from you. Thanks, RRC

$50 CAD за 2 дні(-в)
(30 відгуків(-и))
5.6
mlirzl97

Hi there. Accountant here ready to assist you in your reconciliation needs. Let me know thru chat. Thanks.

$30 CAD за 1 день
(2 відгуків(-и))
2.2
ataasc

I am a quickbooks pro advisor and a certified accounting technician with 5 years of experience of bookkeeping and accounting. I can give you complete accounting support as per your requirement. Lets have a chat and Більше

$30 CAD за 1 день
(3 відгуків(-и))
1.4
shabirahmed82

I can do this project for you and find where the discrepancies are and fix them. I can also explore other bugs if any and fix them too.

$25 CAD за 1 день
(0 відгуків(-и))
0.0
tha192004

I believe/trust that you have come across many others who are equipped for the job in terms of capabilities and abilities; however, going through my past experience and work performance you will find out that I am one Більше

$25 CAD за 1 день
(0 відгуків(-и))
0.0
KRGIRIJA

My experience as a Banker, I would be able to reconcile this discrepancy between the two with proper reasoning.

$45 CAD за 1 день
(0 відгуків(-и))
0.0
Udayan25

Hi, Your initial requirement caught my attention and having prior work experience in similar areas I would be more than happy to assist you and build long term relation. I would like to know more detail about the proj Більше

$30 CAD за 1 день
(0 відгуків(-и))
0.0