MYOB Accounting + Advance Excel Combo Pack Basic to Advance

Learn to create a new MYOB company, set up a closing and opening trial balance, and import opening balances using the Tsangarides 2020 assignment as a sample.

Open MYOB, locate the Premium 19 folder, select the Zendejas file, and log in as administrator in multiuser mode. Choose activate later, run data verification, and return to the dashboard.

Edit the chart of accounts in MYOB, create or adjust ledgers, and enter opening balances for assets, liabilities, and control accounts to reconcile customer balances.

Learn how to create a new chart of accounts in MYOB, adding motor vehicles under fixed assets with subaccounts for cost and depreciation, including opening balances and editing balances.

In this lecture, learn to enter opening balances in MYOB by creating asset, cash, bank, and equity accounts, adjusting accumulated depreciation and accrued expenses, and balancing the trial balance.

Extract the trial balance from accounts reports, select the period, and display the financial year's balances to reconcile debits and credits. If discrepancies arise, inspect details by double-clicking the balance.

learn how to enter customers and suppliers with opening balances in MYOB, assign balances, reconcile accounts receivable and payables, and verify with trial balance reports.

Create and configure new inventory items in MYOB, assigning item numbers, tax codes, and linked accounts for buying, selling, and inventory tracking in a trading business.

Learn how to enter inventory opening balances in MYOB by setting quantities and unit costs, creating an opening inventory journal, and reviewing the impact in trial balance reports.

Enter opening balances and verify the trial balance in MYOB, then distinguish trading and non-trading activities and record journal entries (furniture purchases, prepaid rent, security deposits, maintenance).

Receive cash payments from customers in MYOB to settle open sales balances, as demonstrated with Mr. Mubarak paying 40,000 against a previous balance on 7 January 2020.

Enter purchase invoices on credit in MYOB, select Daniel, switch to item layout, record Corolla windscreen, Civic headlights, Suzuki wheel cups, and add Suzuki filters (new item) with GST-free settings.

Enter a new supplier and record a multi-item purchase invoice part 2 with correct quantities, rates, dates, and invoice numbers for items like Corolla windscreen, Civic headlights, and Suzuki filters.

Record cash sales in MYOB by creating a walk-in customer, entering a cash sale invoice, and marking payment as cash. Review journal entries behind the scenes.

Master how to record customer advances in MYOB by creating a sales order, receiving a cash advance, and posting to a customer advances liability until delivery.

Enter direct credit sales in MYOB by issuing a sales invoice after delivery, recording the journal entries for receivables, cost of goods sold, and inventory reduction.

Enter a purchase order in MYOB by creating an order, selecting the vendor, adding items with updated prices, and recording the transaction after confirming totals and tax code.

Learn how to record bad debts in MYOB, adjust unrecoverable customer balances, and settle opening balances by applying sixty thousand with debit and credit entries.

Record a service invoice in MYOB; switch to service layout, create a new supplier, post packing charges to cost of sales, and see debit and credit in the transaction journal.

Learn how to pay invoices in MYOB by applying a bank check payment to an open bill as a partial settlement, then balance to zero and review the transaction journal.

Convert a sealed sales order to a sales invoice after delivery by using the invoice template and recording journal entries for receivable, cost of goods sold, inventory, and deposits.

Learn to process purchase returns in MYOB by recording negative quantities, converting to item invoices, applying returns to supplier payables, and reconciling inventory and debits.

Record a sales return in MYOB by posting a negative quantity against the item invoice, then apply the return to the pending invoice and review the transaction journal.

Receive cash payments from a customer against two invoices, ensure deposit account is cash in hand, and use receive all to clear open balances.

Learn how to convert a purchase order into a purchase invoice in MYOB, turning pending orders into bills, recording them, and recognizing the impact on trade creditors and inventory.

Record inventory loss in MYOB by treating damaged stock as an indirect expense, adjusting quantity via the inventory journal, and renaming the expense account to loss of inventory.

Identify and record an adjusting journal entry in MYOB to recognize January rent expense from six months' prepaid rent, moving 5,000 from prepayments to rent expense.

Extract and review the trial balance from accounts, reconcile discrepancies by matching transactions to ledgers, and attach supporting reports for final closing and the upcoming manufacturing company assignment.

Apply Myob accounting and Excel to Ravi Textile Mills, setting up opening trial balance, opening inventory balances, and bill of materials for converting raw materials into shirts and pants.

Set up a Ravi Textiles manufacturing company in MYOB, create the company, configure year 2020 as the financial year, and choose a starter chart of accounts for a manufacturing business.

Enter ledger opening balances in MYOB by renaming ledgers and entering asset, liability, and equity balances including cash in hand, debtors, inventory, machinery, and net owners equity.

Add customers and vendors, then enter their opening balances and ensure the balances match the receivables control account, using GST free by default.

Learn to update supplier records and enter opening balances in MYOB, set GST free on supplier details, and verify each balance for accuracy.

Enter raw material opening balances in MYOB, assign assets to inventory, and verify with a trial balance before producing finished goods.

Create finished goods in MYOB by defining a bill of materials recipe for each item, detailing the raw materials and quantities per unit to manufacture shirts and pants.

Settle accrued expenses in MYOB by debiting the accrued expenses liability and crediting cash, reflecting a 200,000 cash payment and updating opening balances as a non-trading journal entry.

Record a purchase order in MYOB by entering purchases, selecting the supplier, setting the date, quantity, and price, and confirming the total before recording.

Discover how to extract entered records by separating financial-impact transactions from non-financial ones, view them via budgetary issue and transaction journals, and save corrections.

convert a partial purchase order to a purchase invoice in MYOB by selecting the open order, creating a bill, and adjusting the quantity while keeping the rate.

Learn to enter direct purchase invoices in MYOB by creating a supplier bill for Forrey Textiles (without any order), inputting items and prices, and posting a journal entry.

Enter a sales order for future delivery of finished goods when stock is unavailable. Learn to record customer orders, specify quantities and prices, and edit or delete orders as needed.

Demonstrates transferring twenty five thousand from bank to petty cash for office use, debiting petty cash and crediting bank, with a journal entry and updated balances.

Practice receiving cash against customer invoices in MYOB, apply partial payments, choose cash as the payment method, and review the resulting journal entries for cash debit and debtors balance reduction.

Enable multiple currencies in MYOB via the Easy Setup Assistant, select and edit a currency, and set it as the default to apply across existing records.

Learn to record direct dyeing services in MYOB by creating a new service item, switching the invoice template to service, and posting costs to cost of goods sold for inventory.

Discover how to record cash services in MYOB, including creating a cash vendor, posting a two-step journal (debit services, credit creditors, then cash in hand) and setting cash as default.

Learn how to record customer advances against a sales order, treat customer deposits as a liability, and link payments to open orders using a step-by-step example.

Record travel expenses paid by bank using either a journal entry or the spend money option in banking, with a 5000 debit to travel expenses and 5000 credit to bank.

Learn to record repair expenses for an office building paid by cheque from MKB Bank through MYOB, posting a fifty-five thousand journal entry and aligning memo notes.

Record motor vehicles at cost purchase paid by bank check in the banking section, with check number 8028802 on 14 January 2019 for 50,000, and review the journal entry.

Learn to manufacture finished goods from raw materials in myob by building 4,000 shirts and 4,000 pants via assembly on 15 January, consuming raw materials and updating stock in hand.

Learn how to manufacture finished goods from raw materials in MYOB, using inventory steps to build quantities, record transactions, and review the transaction journal.

Learn to handle bad debts in a manufacturing company by converting a receivable to bad debts, applying a credit note to settle the invoice, and recording related expenses.

Convert a sales order to a sales invoice in MYOB, selecting full or partial conversion. Update the date and review the transaction journal for an advance and balance due.

Record a direct sales invoice in MYOB for 500 shirts at 400, totaling 200,000. Post the entry debiting receivables and crediting sales; record cost of goods sold and finished goods.

learn how to convert a sales order to a sales invoice in MYOB, adjust quantities and date, record the transaction, and review related journal entries.

Receive payments against customer invoices by recording cash in hand, settling a single payment across multiple invoices (full and partial), and verifying entries in the transaction journal.

Learn how to process payments against vendor invoices in MYOB, including selecting a supplier, entering check details, recording the payment, and verifying disbursements.

Learn how to process a payment against vendor invoices, apply the payment and settle the account in full, and record the transaction in the journal as a debit.

Learn how to record a fixed asset purchase by cash in MYOB using the spend money option, debit office equipment at cost and credit cash in hand.

Record a partial cash settlement of an SBA loan, reducing the liability from 500,000. The transaction journal captures the dispersement details and the settlement against cash.

Record a purchase return in MYOB by entering a negative quantity and applying it to the supplier invoice to reduce accounts payable.

Learn how to process a sales return in MYOB by recording a negative quantity, applying it to the sale, and reviewing the transaction journal for correct debits and credits.

Record cash purchases of cost of goods sold services in MYOB using banking spend money, assign the cost of goods or services account, and apply the debit and credit entries.

Record director cash withdrawals as capital drawings in MYOB, using journal entry or spend money, credit cash on hand, debit capital drawings, and review the transaction journal and remittance advice.

Demonstrates recording a spoilage loss in MYOB by entering 500 damaged button shirts, debiting shrinkage and spoilage as an expense and crediting raw materials, and reviewing the journal entry.

Record month-end accrued expenses by transferring bills like electricity, rent, salaries, and telephone to accrued expenses, debiting the expenses and crediting bills payable for costs incurred but not yet paid.

Learn to review closing reports, verify entries with the trial balance and balance sheet, and reconcile discrepancies using ledger reports and the general ledger detail.

Congratulates you on completing the MYOB training and hopes the screening serves you well in your real-time assignments; invites you to leave a star-rated review detailing what you liked.

Master basic Excel concepts, including worksheets, cells, and cell addresses, and learn fill series and autofill to automate pattern recognition tasks in the MYOB accounting and advance Excel combo pack.

Create and import custom lists in Excel to store entries for use in workbooks. Access file options and general options, import from Excel sheet, and activate memory for new workbooks.

Learn essential Excel keyboard shortcuts and the golden key concept to navigate the ribbon with the Alt key, highlight ranges with Ctrl+Shift, apply color, alignment, and borders quickly.

Learn fixed and variable references in Excel to understand absolute and relative references, and how dragging the references down updates formulas automatically.

Create a mark sheet in excel for 50 students across five subjects. Auto-generate student numbers and auto-fit column widths; then complete a one-minute scoring task with marks 30 to 90.

generate random numbers in Excel using the ran between formula, bounded 30 to 90, and fill results quickly by dragging or double-clicking.

Select all cells containing the formula, copy them, then use paste special values to replace formulas with their calculated values, preserving the results.

Master calculating student marks in excel using auto sum and fill down to reach 500 for five subjects, then compute percentage by dividing by total marks and formatting as percent.

Apply if-then logic in Excel to determine student status as pass or fail using a 50 percent threshold, with greater than or equal to, and copy the formula across cells.

Learn how to build nested if statements in Excel to automate grading schemes, using looping if logic, proper bracket closure, and auto-fill across cells.

Learn to assign ranking positions using the rank function and compare each student's percentage with all peers. Fix absolute references (F4) to keep the range static as you fill down.

Explore conditional formatting in Excel to automatically highlight outcomes, use color rules and data bars to visualize performance, including red and green highlights and customized formats.

Learn to apply freeze panes in Excel to keep headings and names visible as you scroll, using the intersection point for top rows and first column.

Format data in Excel by applying a predefined table style from the Home tab, with or without headers, and convert the table back to a range to remove formatting.

Master sorting and filtering in Excel to isolate morning batches, apply format painter to fix formatting, and use between and top 10 items to select top students.

Learn essential Excel formulas to calculate subject-wise attendance and marks using count, count blank, max, min, and average, plus conditional counting with count if.

Learn to prepare a sales and bonus report with manual totalling in Excel, calculating January–March totals for sales and profit, freezing price with F4, and inserting grand totals.

Master grouping and auto totaling in Excel to create expandable month-by-month summaries with subtotals and a grand total, using the data tab and the expand collapse controls.

Learn to create expandable summary reports in Excel by hiding and grouping rows, applying subtotals and auto totaling, and switching between detailed and summary views for month-by-month performance.

Remove duplicates and subtotals in excel, then build a salesperson sales summary using sum if to total units, sales, and profit by each salesperson.

Master absolute and relative referencing in Excel by learning how dollar signs fix columns or rows, and how dragging formulas makes references move.

Learn to apply sumif with absolute and relative references to automate totals across a sales dataset, fixing columns with dollar signs while allowing rows to adjust.

Apply sumif with external sheet references to pull number of units sold from the bonus report into the sales report, using absolute and relative references and F4 to fix ranges.

Learn to build Excel if formulas with multiple logics to award bonuses based on units sold and customer reach, using and/or conditions and fixed references.

Understand aged debtors analysis by tracking invoices due under credit terms and aging them by time past due, with a practical data example and reporting considerations.

Learn how to clean and arrange data exported from accounting software by identifying merged cells, unmerging, and using paste special skip blanks to align headings with thousands of transactions.

Learn to automate data arrangement in Excel by recording macros, enabling the Developer tab, and attaching a macro to a button to auto arrange and refresh reports.

Discover formatting tricks in Excel: bold brown text in the first column, highlight the second row, add borders, remove underline, and use the format painter, teaser on conditional formatting.

Learn to build conditional formatting formulas in Excel to highlight payment statuses, using fixed columns and heading references so cleared turns green and uncleared turns red across the table.

Apply advanced Excel formatting tricks using conditional formatting to highlight headings. Create a fake heading, name the range, and build two rules to color headings and the corresponding rows.

Learn aging analysis for receivables by calculating months past due, extracting month and year from dates, and automating outstanding balances with Excel formulas such as IF, ISBLANK, MONTH, and YEAR.

Learn to apply absolute and relative references in Excel, drag formulas across months and rows, fix columns with dollar signs, and use date value checks for aging analysis.

Create a live aging analysis in Excel to categorize open balances by days past (0–30, 31–60, 61–90, 91–120, 180+), updating automatically with today’s date and using absolute and relative references.

Explore advanced searching with vlookup, using leftmost column, exact and approximate matches, and fixed table ranges to retrieve make, location, warranty, and price from a car parts inventory.

Name ranges to simplify formulas and keep references fixed. Use if error to return blank for missing values, and perform lookups with exact match on a named table.

Apply data validation to restrict inputs to a predefined list, create a named range, and use a dropdown to select car parts, reducing spelling errors and manual entry.

Explore how to create and configure Excel combo boxes with ActiveX controls, linking to a list for autocomplete, data validation, and dynamic updates in a lazy yet efficient workflow.

Explore how to use the hlookup function in Excel to flip data tables with transpose, extract values across rows, and build dynamic lookups with fixed references and data validation.

Learn how Excel lookups work, including leftmost-column rules, fixed versus moving references, and when to sort data to retrieve car parts and product codes.

Learn how the index and match functions identify the lowest bid and return the corresponding vendor name with exact match lookups.

Develop an automatic invoicing system for Remington Pharmaceutical Industries Private Limited that retrieves medicine details by name, calculates price by quantity, applies discount bands, and outputs the net amount.

Master vlookup and match to fetch invoice details from a data table using named ranges and absolute references. Use approximate match for discounts and compute totals and net amounts.

Learn to summarize sales data in excel using sumif and ifs, computing total sales by product and by salesperson, while managing duplicates and multi-criteria limitations.

Create a dynamic search box and use the DSUM database formula to sum sales by criteria in an Excel table. Learn how headings and fields map criteria to totals.

Use advanced filters and macros in Excel to extract transactions by criteria with a dynamic search box like Motor City. Automate refresh with recorded macros and VBA.

Explore how to create and customize pivot tables in Excel to build regional and salesperson sales reports, drag fields, switch layouts, and analyze products across regions.

learn to build a month-by-month regional sales report using pivot tables, group by month and year, place region in columns, and summarize sales with built-in formatting.

Create and analyze pivot tables in excel to compute sales, cost of goods sold, and profit using calculated fields, then refresh and adjust data sources as needed.

Learn to apply pivot charts to data analysis, choosing line graphs for trend analysis and bar, clustered column, or 100 percent stacked columns for clear yearly and product comparisons.

Explore building dashboards in Excel by using pivot tables and charts to analyze monthly sales, by sales rep and product, with timelines and slicers to filter region and performance.

Automate payroll cheque printing by linking Excel with Word via mail merge, using a spell number module in VBA to convert amounts to words and print cheques with fewer errors.

Create Excel hyperlinks to external sites, internal sheet data via defined names, and linked files, and format links to look like regular text for seamless integration.

Hyperlink external references to quickly access bank, salaries, and staff data from a data mapping workbook, and learn to keep links stable when file locations change.

Split a full name into first and last names using Excel's text to columns with a delimited space option, then learn to recombine them into a full name with concatenation.