Design a spreadsheet to import a MYOB payroll file and prepare journal entries.
Input: MYOB payroll report in Excel
Process: Sort by account codes. Allocate wages and superannuation expense to sub accounts (up to 6) based on table of percentages. Also calculate accrued wages and superannuation expenses where the payroll period spreads over 2 months.
Output: Summary of journal entries including sub accounts.
10 freelancers are bidding on average $121 for this job
I will design an Excel sheet for journalising Payroll Relevant Skills and Experience I am expert in excel Proposed Milestones $140 AUD - Excel Sheet for Payroll Journalizing Please provide more details
I am an expert of Ms- Word, Ms- excel, Ms- Access, Ms- Power point and my typing speed is very good. I have 4 years’ experience as a data entry operator and also I do proofreading and internet research.