Financial Reporting Assignment
· Create a back-up of your MYOB file. Save it in your computer.
· Use the following name to save:
· [your full name] [your class] Financial Reporting MYOB Backup ZIP file
Copyright By PowCoder代写 加微信 powcoder
e.g. AC… Financial Reporting MYOB Backup ZIP file
SAVE TO PDF
VERY IMPORTANT MESSAGE
1) COPY YOUR MYOB FILE ON USB BEFORE YOU CONTINUE
2) REFER TO PAGE 11 of this instruction booklet on how to save to PDF
PDF – 1. Transaction Journal [All] for June
PDF – 2. Bank Reconciliation Report for June
PDF – 3. Bank Reconciliation Report for July
PDF – 4. Profit and Loss Accrual
PDF – 5. Balance Sheet
PDF – 6. General Ledger [Detail]
PDF – 7. Trial Balance for 30 June 20__
PDF – 8. Accounts Receivable Reconciliation Summary
PDF – 9. Accounts Payable Reconciliation Summary
PDF – 10. Account List [Detail]
PDF – 11. Card List
PDF – 12. Inventory List [print screen]
PDF – 13. Transaction Journal – July [after roll-over]
SAVING TO PDF Instructions – MYOB
USE 2020 AS THE YEAR WHEN ENTERING THE DATES
1. PDF 1 – Transaction Journal [ALL]
Go to Accounts Command Centre.
Click on Transaction Journal.
Set date from 01/06/20_ to 30/06/20__
Select the “All” tab to show all types of transactions.
Select Print
Choose Microsoft Print to PDF
Save as PDF – 1. Transaction Journal – June
2. Bank Reconciliation Report 30 June 2020
Go to ‘Reports’ menu.
Click on ‘Index to Reports’.
Select the ‘Banking’ tab.
Under the ‘Cheques and Deposits’ subheading, select ‘Reconciliation Report’.
Click on ‘Customise’ button under the list of reports.
Under the ‘Advanced Filters’ tab, set statement date to 30/06/…..
Select Send to:
Choose PDF
Save as PDF – 2. Bank Reconciliation Report June
3. Bank Reconciliation Report 1 July 2020
Go to ‘Reports’ menu.
Click on ‘Index to Reports’.
Select the ‘Banking’ tab.
Under the ‘Cheques and Deposits’ subheading, select ‘Reconciliation Report’.
Click on ‘Customise’ button under the list of reports.
Under the ‘Advanced Filters’ tab, set statement date to 1/07/…..
Select Send to:
Choose PDF
Save as PDF- 3. Bank Reconciliation Report for July
4. Profit and Loss Accrual 30 June 2020
Go to ‘Reports’ menu.
Click on ‘Index to Reports’.
Select the ‘Accounts’ tab.
Under the ‘Profit & Loss’ subheading, select ‘Profit & Loss [Accrual].
Click on ‘Customise’ button under the list of reports.
Under the ‘Advanced Filters’ tab, set statement date from 1/7/2019 to 30/06/2020
Select Send to:
Choose PDF
Save as PDF – 4. Profit and Loss Accrual
5. Balance Sheet 30 June 2020
Go to ‘Reports’ menu.
Click on ‘Index to Reports’.
Select the ‘Accounts’ tab.
Under the ‘Balance Sheet’ subheading, select ‘Standard Balance Sheet”
Click on ‘Customise’ button under the list of reports.
Under the ‘Advanced Filters’ tab, set statement date to 30/06/20..
Select Send to:
Choose PDF
Save as PDF – 5. Balance Sheet
6. General Ledger
Go to ‘Reports’ menu.
Click on ‘Index to Reports’.
Select the ‘Accounts’ tab.
Under the ‘Accounts’ subheading, select ‘General Ledger – Detail’.
Click on ‘Customise’ button under the list of reports.
Under the ‘Advanced Filters’ tab, set date from 01/06/…… to 30/06/…..
Under the ‘Report Fields’ tab, remove the tick from the ‘Job No.’ field.
Under the ‘Finishing’ tab, remove the tick from ‘Include Accounts with No Activity’.
Click on Display to display the report.
Select Send to:
Choose PDF
Save as PDF – 6. General Ledger [Detail]
7. Trial Balance
Go to ‘Reports’ menu.
Click on ‘Index to Reports’.
Select the ‘Accounts’ tab.
Under the ‘Accounts’ subheading, select ‘Trial Balance’.
Click on ‘Customise’ button under the list of reports.
Under the ‘Advanced Filters’ tab, set the period to ‘June’.
Under the ‘Finishing’ tab, remove the tick from ‘Include $0.00 Balances’.
Click on Display to display the report.
Select Send to:
Choose PDF
Save as PDF – 7. Trial Balance
Accounts Receivable Reconciliation [Summary]
Go to ‘Reports’ menu.
Click on ‘Index to Reports’.
Select the ‘Sales’ tab.
Under the ‘Receivables’ subheading, select ‘Reconciliation Summary’.
Click on ‘Customise’ button under the list of reports.
Under the ‘Advanced Filters’ tab, set the date of the report ‘30/06/2020’.
Click on Display to display the report.
Select Send to:
Choose PDF
Save as PDF – 8. Accounts Receivable Reconciliation [Summary]
9. Accounts Payable Reconciliation [Summary]
Go to ‘Reports’ menu.
Click on ‘Index to Reports’.
Select the ‘Purchases’ tab.
Under the ‘Payables’ subheading, select ‘Reconciliation Summary’.
Click on ‘Customise’ button under the list of reports.
Under the ‘Advanced Filters’ tab, set the date of the report ‘30/06/2020’.
Click on Display to display the report.
Select Send to:
Choose PDF
Save as PDF – 9. Accounts Payable Reconciliation [Summary]
10. Accounts List Detail
Go to ‘Reports’ menu.
Click on ‘Index to Reports’.
Select the ‘Accounts’ tab.
Under the ‘Accounts’ subheading, select ‘Accounts List Detail’.
Click on ‘Customise’ button under the list of reports.
Set the date of the report ‘30/6/2020’.
Click on Display to display the report.
Select Send to:
Choose PDF
Save as PDF – 10. Accounts List [Detail]
11. Card List Detail
Go to ‘Reports’ menu.
Click on ‘Index to Reports’.
Select the ‘Cards’ tab.
Under the ‘Cards’ subheading, select ‘Card List Summary’.
Click on Display to display the report.
Select Send to:
Choose PDF
Save as PDF – 11. Card List [Summary]
12. Print Screen of “Inventory List”
Go to the ‘Inventory Command Centre’.
Select ‘Items List’.
Using the keyboard, hold the ‘Ctrl +Alt + PrtScn’ keys together.
(Note: If your keyboard shows ‘Print Screen’ in blue, you must press the blue ‘Fn’ key in addition to the other keys. ie. ‘Ctrl + Alt + Fn + Print Screen’
Open Word to save as PDF or paint to save as a picture
Click on the ‘Paste’ button. The screen capture should appear.
Save as PDF 12. Inventory Print Screen
NOTE: You can use snipping tool if you have the Windows Accessories in the menu and save as a picture
BEFORE YOU ROLL OVER YOUR MYOB FILE MAKE SURE YOU HAVE A COPY OF YOUR MYOB BUSINESS ON YOUR USB AND YOU HAVE PDF 1-12 SAVED ON YOUR COMPUTER. ONCE YOU ROLL OVER YOUR BUSINESS YOU WILL NOT BE ABLE TO SAVE PDF 1-12
ROLL OVER Perform a financial year end rollover in MYOB.
WARNING: HAVE YOU PERFORMED A BACK-UP
DO NOT PERFORM A ROLLOVER UNTIL YOU HAVE SAVED ALL DOCUMENTS IN THE PREVIOUS STEP TO PDF AND YOU HAVE PERFORMED A BACK-UP
****** COPY YOUR MYOB FILE ON USB BEFORE YOU ROLLOVER****
****** PERFORM A BACK-UP BEFORE YOU ROLL-OVER****
Once a rollover occurs you will not be able to undo this so it is VERY VERY IMPORANT YOU HAVE a COPY OF YOUR MYOB BUSINESS ON a USB AND YOU HAVE PERFORMED a BACK-UP
· SAVE TO PDF a Transaction Journal “all” for the dates 1/7/20– [today’s date]. This journal should only contain the retained earnings transaction generated by the MYOB system when performing the rollover.
REFER TO PAGE 11 of this instruction booklet on how to save to PDF
13. Transaction Journal after roll over
Go to Accounts Command Centre.
Click on Transaction Journal.
Set date from 01/07/20_ to [today’s date]
Select the “All” tab to show all types of transactions.
Select Print
Choose Microsoft Print to PDF
Save as PDF – 13. Transaction Journal – July after roll – over
**************** You have created 13 MYOB reports ******************
Please Use the link below to combine or merge all 13 MYOB reports into ONE PDF.
https://combinepdf.com/
1) upload 13 PDFs in the correct order
2) Choose “Combine”
3) “Download” the combined PDF.
4) Now you have ONE PDF file includes all 13 MYOB reports.
1. Transaction Journal “all” – 1/6/20 – [today’s date]
PDF – 1. Transaction Journal – June
2. Bank Reconciliation statement 30 June 2020
PDF – 2. Bank Reconciliation Report June
3. Bank Reconciliation in July
PDF- 3. Bank Recon Report for July
4. Profit and Loss [Accrual] (1 July 2019 – 30 June 2020)
PDF – 4. Profit and Loss Accrual
5. Balance Sheet (June)
PDF – 5. Balance Sheet
6. General ledger [Detail] for the month of June– remove zero balances; no accounts with no activity
PDF – 6. General Ledger
7. Trial balance for 30 June 2020
PDF- 7. Trial Balance for 30 June 2020
8. A/c Receivable Reconciliation [Summary]
PDF – 8. Accounts Receivable Reconciliation
9. A/c Payable Reconciliation [Summary]
PDF – 9. Accounts Payable Reconciliation
10. Account List [Detail].
PDF – 10. Accounts List
11. Card List
PDF – 11. Card List
12. Inventory List [print screen]
PDF- 12. Inventory List
13. Transaction Journal “all” (after roll-over) for July – 1/7/20 – [today’s date]
PDF – 13. Transaction Journal – July
D. Back-up file in Uploaded to Moodle (correctly named).
SUBMISSION
Upload the following files to Moodle by due date.
1. Completed Financial Reporting EXCEL file (correctly named)
Use the following name to save:
· [your full name] [your class] Financial Reporting Assignment Excel
e.g. AC… Financial Reporting Assignment Excel
1. Your MYOB PDF Reports merged together into one document. Name the file [your full name] [your class] Financial Reporting Assignment MYOB Reports
How to combine PDF files online:
2. Go to the website https://smallpdf.com/merge-pdf
3. Drag and drop your PDFs into the PDF combiner.
4. Rearrange individual pages or entire files in the desired order.
5. Add more files, rotate or delete files, if needed.
6. Click ‘Merge PDF!’ to combine and download your PDF.
7. Rename the File [your full name] [your class] Financial Reporting Assignment MYOB Reports
Make sure your file names follow the file name convention indicated below.
PDF – 1. Transaction Journal [All]
PDF – 2. Bank Reconciliation Report for June
PDF – 3. Bank Reconciliation Report for July
PDF – 4. Profit and Loss Accrual
PDF – 5. Balance Sheet
PDF – 6. General Ledger [Detail]
PDF – 7. Trial Balance for 30 June 20__
PDF – 8. Accounts Receivable Reconciliation Summary
PDF – 9. Accounts Payable Reconciliation Summary
PDF – 10. Account List [Detail]
PDF – 11. Card List
PDF – 12. Inventory List [print screen]
PDF – 13. Transaction Journal – July [after roll-over]
8. Your MYOB Backup ZIP file (correctly named)
Use the following name to save:
· [your full name] [your class] Financial Reporting MYOB Backup ZIP file
e.g. AC… Financial Reporting MYOB Backup ZIP file
It is important for you to complete this process exactly to ensure all your assignment can be fully graded. Please ask your teacher if you have any questions.
INSTRUCTION BOOK 14 Feb 2020 (v1.1)
程序代写 CS代考 加微信: powcoder QQ: 1823890830 Email: powcoder@163.com