Design a spreadsheet to journalise payroll

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

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.

Accounting Excel Finance MYOB

Project ID: #15659488

About the project

10 proposals Remote project Active 6 years ago

Awarded to:

renesontiongson

Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much. Relevant Skills and Experience Excel automation Proposed Milestones $100 More

$100 AUD in 1 day
(63 Reviews)
5.4

10 freelancers are bidding on average $121 for this job

integrahup

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

$140 AUD in 5 days
(4 Reviews)
3.0
mikhailkozalski

I am good at this part. Relevant Skills and Experience Excel, Excel VBA Proposed Milestones $200 AUD - discuss

$200 AUD in 3 days
(3 Reviews)
2.6
rizwanjpi

Hello, I am expert in Excel vba/macro. I have done 600+ vba projects on upwork. So i can make vba for you to import your myob data to excel and sort them with your given criteria. Thanks Relevant Skills and Experien More

$111 AUD in 3 days
(1 Review)
0.6
arif758

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.

$100 AUD in 3 days
(1 Review)
0.6
Kiranchandrasaha

Hello Dear, I have read the details and lot of experience Accounting, Excel, Finance, MYOB Task and different types of projects. I am waiting for your quick positive reply. Best Regards, Kiran Saha Relevant Skills an More

$55 AUD in 2 days
(1 Review)
0.1
riponhossen96

I would like to work on this project. I have done a lot of similar project of this. I think that I can help you on this project. Feel free to let me know if you would like to look a sample.. Relevant Skills and Exper More

$111 AUD in 3 days
(0 Reviews)
0.0
Bustercrab

G’day, I am based out of Mandurah in Western Australia. I have an advanced business honed skill set with Microsoft Excel, with twenty years’ experience working in many different industries. Stay tuned, I'm still work More

$166 AUD in 2 days
(0 Reviews)
0.0