Видео

👉 TO BOOK IN A TRAINING SESSION: www.qtraining.net.au If an error is made when posting payroll in Xero, the payroll clerk will have two choices: - Reverse out the incorrect pay run, then re-post correctly - Post a correction pay run with the net adjustment figures In this video I show you how to fix a payroll pay run error in Xero by posting a new pay run with the net adjustment figures. This m...

👉 TO BOOK IN A TRAINING SESSION: www.qtraining.net.au If you have posted a pay run in Xero and then realise that you made an error and need to adjust the payroll, Xero will not allow you to revert it to draft if you have also filed the STP report. In this case you will need to post either an adjustment or a reversal. If you post a reversal unscheduled pay run, you will then need to re-post the ...

👉 TO BOOK IN A TRAINING SESSION: www.qtraining.net.au If you have ever tried to post a sale or raise an invoice in Xero for a product that you know you have stock on hand for, but the Xero system won't allow you to post the invoice because according to Xero there is insufficient stock quantity in hand, you will need to make an inventory adjustment in Xero so that you can post the invoice and co...

👉 TO BOOK IN A TRAINING SESSION: www.qtraining.net.au There are times when you may need to make an adjustment to the tax withheld from an employees wage in Xero so that it matches the amount that was paid from the bank. For example: - You might be doing Xero bookkeeping catch-up work - The business owner may have been paying the wrong after-tax amount - The tax taken out of a one-off payment ma...

👉 TO BOOK IN A TRAINING SESSION: www.qtraining.net.au Here I will show you how to use the various options when allocating and entering transactions for the Xero bank reconciliation. The main choices for reconciling transactions in Xero are: - Match - Create - Transfer - Discuss - Find & Match After watching this video you will know what all of theses transaction allocating options do, and when ...

👉 TO BOOK IN A TRAINING SESSION: www.qtraining.net.au Here I show you how to process a customer overpayment in Quickbooks Online (QBO). There are a few steps required to process an overpayment transaction in Quickbooks Online. You will need to create a credit note in the QBO system for the customer overpayment. And the method will change depending on whether the credit note will be offset again...

👉 TO BOOK IN A TRAINING SESSION: www.qtraining.net.au The VLookup formula is very handy for pulling related data from one sheet over into another spreadsheet that is in a different format. Rather than spending large amounts of time copying and pasting data, the VLookup function will automate your task and save you a lot of time. VLookup is one of the most commonly used Excel functions or formul...

👉 TO BOOK IN A TRAINING SESSION: www.qtraining.net.au The Concatenate formula is very handy when you want to combine data from more than one column into a single column. I used this recently when I was doing a software conversion from MYOB to Xero. I needed to combine a column that had first names with a column that had second names into a single column that displays the first and last name. So...

👉 TO BOOK IN A TRAINING SESSION: www.qtraining.net.au In this video we show you how to set up track and process time in lieu in Xero. Time off in lieu is when an employee works extra hours during a pay cycle and then instead of getting the extra pay (and the extra tax) in that pay, they opt to work less hours in a future pay cycle and get paid for the time in lieu instead. Time in Lieu can also...

👉 FOR TRAINING & COURSES: www.qtraining.net.au Here we will show you how to pay multiple suppliers in one go using Quickbooks online accounting software. By creating a batch file in Quickbooks, you are able to export an aba payment file into your online banking to pay a batch of supplier invoices in a single transaction. When you import an ABA payment file into your bank, you not only automate ...

👉 TO BOOK IN A TRAINING SESSION: www.qtraining.net.au Here we show you how allocate the principal and interest components of a fixed asset loan repayment in Xero. Often when a business purchases a new fixed asset such as a new motor vehicle car or piece of equipment, the purchase will be financed by a lendor. The business will then make monthly repayments to pay for the fixed asset purchase. Th...

👉 TO BOOK IN A TRAINING SESSION: www.qtraining.net.au Recently when windows did a self update, I encountered an error when attempting to open a company file on the old MYOB classic desktop software, AccountRight Premier v19.13. The error window that popped up in the Myob login screen stated: Initialisation Error. In this video I show you how to fix the initialisation error for Myob Account Righ...

👉 FOR TRAINING & COURSES: www.qtraining.net.au When you are coding the GST tax code for an expense or income in Quickbooks online, you have to select the applicable GST tax code. There are several GST tax codes available for selection, such as: - GST on Non-capital (Purchases) - GST Free Non-capital (Purchases) - GST on Capital (Purchases) - GST Free (Sales) - Input Tax (Sales) - Input Tax (Pur...

👉 FOR TRAINING & COURSES: www.qtraining.net.au In this video we show you how to add an adjustment note in quickbooks so that we can write off a bad debt on an invoice that is not recoverable. A bad debt is when a customer refuses to pay your invoice for whatever reason. To write off the bad debt we need to create a credit note which is called an adjustment note in quickbooks. #quickbooks

How to track Depreciation in Excel

Employee Loan/Advance on Pay | Xero

How to Enter a Purchase in Xero when GST it is Not a full 10%

MYOB | Close a Financial Year

How to Lock Cells in Excel

MYOB | Export ABA Bank File

MYOB | Automate Invoicing

MYOB | How to Reverse a Supplier Payment

MYOB | How to Write Off a Bad Debt

MYOB | How to Delete a Payroll Pay-run

MYOB | How to Delete a Transaction

MYOB | Set up New Income and Expense Accounts & Formatting

MYOB | What are all the different Tax codes used for?

MYOB | How to set up a new Fixed Asset Account

MYOB | Automate bank reconciliation using Manage Rules