Microsoft Office Accounting - Setup required & Annual Accounts

  • Posted
  • Proposals 0
  • Remote
  • #11461
  • Expired
  • 1

Description

Experience Level: Intermediate
I run an online retail business and require setting up on Microsoft Office Accounting Professional 2009.

These are my prerequisites:

- Use of \'Accountant Transfer\' feature for ease of use as we progress through this project.

- Importing of individual sales records (all imported records will be for completed sales that have been paid for in full, and this is how I intend to use the program in the future).

- Categorisation of individual sales into product categories for reporting functionality (for example, Gucci Sunglasses or Dior Frames).

- All sales data will be in spreadsheet form and include the necessary elements for you to import easily.

- Sales are in 4 seperate currencies. Preference would be to import data in its original currency and perform some kind of conversion directly in MSA - a list of daily exchange rates for the entire period is available if it is possible to import them into the system in this way.

- No bank reconciliation, customer records or stock control required.

- Setting up of nominal codes - I have already created a list of relevant categories.

- Importing of expense data. Again all data will be for invoices that have been paid in full (except to one supplier) thereby negating the need for bank reconciliation.

My first year of trading ended 5 April 2008, so all the data to be imported is for everything after that date. I have everything relating to trial balances, debtors, creditors etc for the initial period.

Once all the data is in the system, I would like to generate my end of year accounts to take me up to April 2009.

I became VAT registered in July, so my first VAT return is due in about 6 weeks. If possible I would like to do this through MSA.

I also run two other much smaller online businesses and would like to setup the sales and expenses for these as seperate departments (or even seperate companies) on MSA. If setting up as seperate companies the totals would have to be factored in for the end of year accounts with the main company as I am a sole trader.

Once the system has been brought up to date, I will require training on certain aspects, such as how to import sales data on a monthly basis and make use of the reporting functionality of MSA.

When responding to this job, please highlight your knowledge and experience of MSA, whether you are capable of completing the end of year accounts, and how you would deal specifically with the seperate companies, multiple currencies and categorisation.

The more detail you give, you more likely you are to be approved for this project.

Many thanks.

Clarification Board

    There are no clarification messages.