Encerrado

P&L data entry, analysis and report preparation - ongoing

We are seeking an accounting professional to enter P&L data into a customized database and prepare a report from the data.

Our clients are small retailers who send us a P&L each quarter. Each of the P&Ls are entered into a database which compiles a benchmark comparison for each shop in about 30 different cost and income areas. The accountant needs to learn the quirks of this retail segment because the job involves matching each individual shop's P&L items to the standardzed ones used to produce the benchmark report. We will train this function and check the work until the accountant is proficient.

Once the data is entered, the report is proofed and a brief analysis (200 - 400 words) is prepared from pre-written copy we will provide. Each report will list the shop's achievements and areas that need improvement (see the sample below).

There are currently 60 retailers with a new P&L each quarter, we expect that to increase to 100 within a year. The accountant will enter the data, balance and proof the report, and compile an email to accompany the report. This will be sent it to us for review, edits and then forwarding to the client. This is an ongoing project that repeats every quarter.

Once the process is up and running, we expect a draft report within 48 after the P&L is sent to the contractor. The P&L is sent as a pdf file.

Pricing:

The data entry process currently takes 15 to 45 min depending on the complexity of the retailer's P&L. Some have 30 lines of income and expenses and others have 200 lines. Questions, adjustments, revisions and proofing add 10-20 min and writing the analysis takes 10-20 min.

We would like a bid per-report per-quarter with the assumption that you will be processing at least 60 reports each quarter (4 times per year). Alternately, you can work by the hour with a budget set for each report.

Here is a sample text that accompanies the report:

Dear Ann:

Enclosed is your Benchmark Report for the 3rd quarter of 2009. You showed a nice 7.5% benchmarked profit. The potential based on your overall expenses is 24.1% if you can bring your labor and facility costs down.

Fresh COGS - you did an excellent job of controlling your fresh costs.

Salaries - your total labor cost were over budget by $7,673 -- at 31%, they were 11% high. They should be 20% without the owner/manager and 30% with the owner/manager. I am wondering if some of the shops labor was shared by the garden center? If so allocate what you think is fair and see where you stand. To give you a reference point, your arranged sales supported on average 34 design hours per week during the quarter. That is one full time designer staying busy 7 hours per day. You probably need about 40 hours of sales clerk time to support this volume plus a delivery person.

Facility - you were over in this category by $4,368 or 6%. Did you allocate the right amount between the garden center and the shop? If so, I would count some of your rent as "advertising" cost because of the location. Also, you may have to work around higher than usual rent costs because of the neighborhood.

Overall - you showed a nice 7.5% profit even with being over benchmark in two key areas. This tells us that you are managing all of the other costs exceptionally well.

Recommendation - I would consider spending more on marketing and promotions. There are some pretty reliable direct mail options that work for other shops. Seasonal postcards and a membership letter/card are two that come to mind. I'd like to begin with a Valentine's Day promotion which we can set up this year. How large is your customer list? When was the last time you mailed? You might be able to do a zip code mailing since you are serving a fairly small target-rich area.

Let's discuss this at your convenience. Just call Nicole and set-up a time that is good for you.

Habilidades: Contabilidade, Análise de Negócios, Processamento de Dados

Ver mais: analysis report, preparation, prepare data entry, writing analysis report, project report analysis, Accounting data, preparation comparison, analysis project report pdf, accounting report preparation, report preparation, preparation review, writing text with key words, writing recommendation letter, writing professional letter, writing letter of recommendation, writing center hours, writing a small report, writing a reference letter, writing a recommendation letter, writing a professional letter, writing an analysis, writing analysis, writing a letter of reference, writing a letter of recommendation, writing a good letter of recommendation

Acerca do Empregador:
( 1 comentário ) Tulsa, United States

ID do Projeto: #585500

73 freelancers estão ofertando em média $3210 para este trabalho

garbar

Ready to start,send pm for detail

$3000 USD in 90 dias
(66 Comentários)
6.1
jpriyak1023

Please check PM for details.

$3000 USD in 30 dias
(33 Comentários)
5.7
ACCT001

Please check pm

$3000 USD in 90 dias
(14 Comentários)
5.5
imranamin

Please Check PM

$3000 USD in 30 dias
(24 Comentários)
5.5
nicusornicolae

Hello, please see PM for details. Thank you, Nic

$3250 USD in 90 dias
(1 Comentário)
5.0
gguru

I have experience in [url removed, login to view] to [url removed, login to view] you

$3000 USD in 30 dias
(23 Comentários)
4.8
himanshusofttech

Hi, Ready to start. Thanks Himanshusofttech Team

$3000 USD in 30 dias
(32 Comentários)
4.6
noreen

Please see the PMB.

$3000 USD in 30 dias
(21 Comentários)
4.5
FlashBack

Please view the PMB

$3000 USD in 30 dias
(12 Comentários)
3.9
ecorporate

I and my team of full time accountants and data entry expert handle P&L,annual reports,financial analysis,business plans and financial reporting assignments for several small and medium [url removed, login to view] can handle this for Mais

$3000 USD in 30 dias
(3 Comentários)
3.8
elasticbrains

Hello, I would like to provide my services for this project "P&L data entry, analysis and report preparation - ongoing". I am well aware of the fact that you looking for an energetic and presentable person. Kind Mais

$3000 USD in 7 dias
(1 Comentário)
3.1
fifolab

Hello sir, I can do that.I am student of accounting.I can fulfill your [url removed, login to view]'s do [url removed, login to view]

$3000 USD in 30 dias
(4 Comentários)
2.9
tulzcool

Please see PM

$3000 USD in 30 dias
(5 Comentários)
2.9
BSoftTech

Hi, I can provide data entry and reports on ongoing basis. Please reply to discuss the details . Thanks, John Joachim

$3000 USD em 1 dia
(1 Comentário)
2.7
rrlinto

Quoated for One Year. Quoted rate per project per quarter is USD 13. Number of days required to complete 60 projects on each quarter is 2 days. Our resource persons consist of Indian Chartered Accountatns. We are one o Mais

$3120 USD in 8 dias
(1 Comentário)
2.3
matharpa

I have experience in making accounting report such as GL,AP,AR, CM and PL report. Contact me if interested. My price is for each quarter.

$3000 USD in 15 dias
(1 Comentário)
1.9
hilbllez

Thank you for your considertion, please see PM

$4080 USD in 2 dias
(1 Comentário)
1.2
bposervices1

Please check pm.

$3200 USD in 31 dias
(3 Comentários)
1.0
raidontech

We are ready to start the work upon your confirmation. Pls check our Bid amount per recorn on PMB. Thanks.

$3000 USD in 5 dias
(2 Comentários)
1.0
blueiris8

My bid is per quarter and delivery is per report. I am a US based business analyst with finance experience and an MBA.

$3000 USD in 2 dias
(0 Comentários)
0.0