Design a spreadsheet to journalise payroll

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.

Skills: Accounting, Excel, Finance, MYOB

See more: steel beam design spreadsheet, beam design spreadsheet excel, shopify csv spreadsheet categories product import, payroll accounting entries pdf, payroll journal entry example quickbooks, payroll journal in quickbooks, payroll journal template, how to record outsourced payroll in quickbooks, payroll journal entry template, how to enter payroll liabilities in quickbooks, payroll general ledger, accounting, payroll, design spreadsheet, spreadsheet data clean import database, design spreadsheet questionnaire, design oracle d2k payroll form, graphic design spreadsheet, cam design spreadsheet, blast design spreadsheet

About the Employer:
( 7 reviews ) Sydney, Australia

Project ID: #15659488

Awarded to:


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)

10 freelancers are bidding on average $121 for this job

$155 AUD in 3 days
(7 Reviews)

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)

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)

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)

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)

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)

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)
$122 AUD in 3 days
(0 Reviews)
$111 AUD in 3 days
(0 Reviews)

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)