QTraining
QTraining
  • 78
  • 495 629
How to Make an Inventory Adjustment in Xero
👉 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 collect payment from the customer.
Here I show you how to adjust the inventory stock quantity in hand in Xero so that you can raise an invoice and complete the sale. You may also need to make an inventory adjustment after completing a stock take and realising there are some discrepancies in your stock on hand quantity compared to the quantity on hand in Xero.
#xero
มุมมอง: 93

วีดีโอ

Xero | Manually Adjust Tax Withheld in a Payslip
มุมมอง 122หลายเดือนก่อน
👉 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...
Xero Bank Reconciliation - The Difference between Match, Create, Transfer, Discuss, Find & Match
มุมมอง 2112 หลายเดือนก่อน
👉 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 ...
Process a Customer Overpayment in Quickbooks
มุมมอง 6493 หลายเดือนก่อน
👉 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...
How to use VLookup in Excel
มุมมอง 1624 หลายเดือนก่อน
👉 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...
How to use CONCATENATE in Excel
มุมมอง 1265 หลายเดือนก่อน
👉 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...
Set up Time In Lieu in Xero
มุมมอง 6956 หลายเดือนก่อน
👉 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...
Supplier Batch Payment ABA File | Quickbooks
มุมมอง 3757 หลายเดือนก่อน
👉 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 ...
Allocate Loan Repayments in Xero - Principal and Interest
มุมมอง 3.4K8 หลายเดือนก่อน
👉 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...
Solution: MYOB Initialisation Error
มุมมอง 2.6K8 หลายเดือนก่อน
👉 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...
Which GST Tax Codes do I use in Quickbooks?
มุมมอง 4489 หลายเดือนก่อน
👉 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...
How to Write Off a Bad Debt in Quickbooks Online
มุมมอง 4.3K10 หลายเดือนก่อน
👉 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
มุมมอง 20811 หลายเดือนก่อน
👉 FOR TRAINING & COURSES: www.qtraining.net.au Microsoft Excel is great for tracking and processing depreciation on asset purchases. it allows you to see how the calculations are made and have a full view of what is happening to calculate your depreciation figure on an asset purchase. Most fixed assets will usually be depreciated. There are two types of depreciation: -Diminishing value deprecia...
Employee Loan/Advance on Pay | Xero
มุมมอง 1.7K11 หลายเดือนก่อน
👉 FOR TRAINING & COURSES: www.qtraining.net.au In this video we show you how to process a staff advance on pay or early wage payment in Xero. This can also be used if you loan money to a staff member that will then be repaid over a period of time with instalments taken out of their pay packet weekly earnings. This is the cleanest way to process staff loans and pay advances in Xero. it allows us...
How to Enter a Purchase in Xero when GST it is Not a full 10%
มุมมอง 1.6Kปีที่แล้ว
👉 FOR TRAINING & COURSES: www.qtraining.net.au GST is not always a full 10%. There are a few items that do not attract GST in Australia. When you enter an invoice or a receipt for a purchase that includes non GST taxable items, you will need to split out the GST on Expenses and GST Free Expenses into different lines. You need to do this to record the GST component correctly. When processing rec...
MYOB | Close a Financial Year
มุมมอง 2.3Kปีที่แล้ว
MYOB | Close a Financial Year
How to Lock Cells in Excel
มุมมอง 115ปีที่แล้ว
How to Lock Cells in Excel
MYOB | Export ABA Bank File
มุมมอง 2Kปีที่แล้ว
MYOB | Export ABA Bank File
MYOB | Automate Invoicing
มุมมอง 869ปีที่แล้ว
MYOB | Automate Invoicing
MYOB | How to Reverse a Supplier Payment
มุมมอง 2.4Kปีที่แล้ว
MYOB | How to Reverse a Supplier Payment
MYOB | How to Write Off a Bad Debt
มุมมอง 1.7Kปีที่แล้ว
MYOB | How to Write Off a Bad Debt
MYOB | How to Delete a Payroll Pay-run
มุมมอง 2.4Kปีที่แล้ว
MYOB | How to Delete a Payroll Pay-run
MYOB | How to Delete a Transaction
มุมมอง 4Kปีที่แล้ว
MYOB | How to Delete a Transaction
MYOB | Set up New Income and Expense Accounts & Formatting
มุมมอง 3.6Kปีที่แล้ว
MYOB | Set up New Income and Expense Accounts & Formatting
MYOB | What are all the different Tax codes used for?
มุมมอง 1.5Kปีที่แล้ว
MYOB | What are all the different Tax codes used for?
MYOB | How to set up a new Fixed Asset Account
มุมมอง 2.7Kปีที่แล้ว
MYOB | How to set up a new Fixed Asset Account
MYOB | Automate bank reconciliation using Manage Rules
มุมมอง 1.2Kปีที่แล้ว
MYOB | Automate bank reconciliation using Manage Rules
MYOB | Automate Purchase entry with In-Tray
มุมมอง 1.8Kปีที่แล้ว
MYOB | Automate Purchase entry with In-Tray
Set up Leave loading in MYOB
มุมมอง 1.6Kปีที่แล้ว
Set up Leave loading in MYOB
Process Annual Leave and Sick Leave in MYOB
มุมมอง 5Kปีที่แล้ว
Process Annual Leave and Sick Leave in MYOB

ความคิดเห็น

  • @hybridheroos
    @hybridheroos 10 ชั่วโมงที่ผ่านมา

    Thanks for video but I have to say wow! so manual. What a bad solution to anyone with more than a few employees.

  • @victorialalamovies3414
    @victorialalamovies3414 9 วันที่ผ่านมา

    Sir why it's not working on my laptop i've been trying many Times but it couldn't work

  • @fatmaahmadr8531
    @fatmaahmadr8531 14 วันที่ผ่านมา

    thank youuu sirr, you all the best ❤

  • @Lochnivar
    @Lochnivar 19 วันที่ผ่านมา

    This is great, but what happens when the business owner has already refunded an overpayment and it's already in the bank feed. I.e. Customer mistakenly pays £2500. Business owner (80 years old and gets confused with numbers) pays back £2300 to the same bank account the next day. Then realising his mistake, he pays another £200 the day after to make up the entire £2500 refund. What do I do with the 'spent money' transaction lines in the bank feed? I've tried finding and matching via the contact name but it doesn't let me reconcile against the Overpayment and if I use the cash method I assume I'll create another transaction line? I'm half tempted to just delete the transaction lines since they balance each other out but I doubt this is the right way to go. Thanks!

  • @user-ll6ri6cy9h
    @user-ll6ri6cy9h 27 วันที่ผ่านมา

    How would you recommend dealing with off payroll payments in Xero please in respect to recording NICs and PAYE paid at source? I was told manual journals but not clear on what the debit and credit entries would be. Thanks.

  • @kanlayaiadsuk4081
    @kanlayaiadsuk4081 29 วันที่ผ่านมา

    Great explanation and easy to understand

  • @loraprow9794
    @loraprow9794 หลายเดือนก่อน

    Thankyou, very helpful. The help instructions in QBO do not explain it like this

  • @profound_thoughts
    @profound_thoughts หลายเดือนก่อน

    Is this MYOB AccountRight Plus?

  • @BiancaKongas-c2x
    @BiancaKongas-c2x หลายเดือนก่อน

    With the example were there is no invoice this all makes sense but will there not be an issue with fees such as Square or After pay that include GST if you are adding a negative to that bank fee account, would you not then miss out come BAS time on claiming back that portion of the GST on your fee expense? For example lets say the example of $210.00 sale with a $10.00 Fee from Square which is inclusive of GST Allocate $210.00 to Sales (GST on Income) Allocate -$10.00 to Square fees (GST on Expenses) How do we then ensure that the GST from the fee/expense is accounted for and claimable on my BAS for GST on Expenses ? I have been looking through so many videos and I cannot seem to find the answer.

  • @se4ld1onn
    @se4ld1onn หลายเดือนก่อน

    i love you sir, i can do my assignment now :D

  • @Blackwidow0307
    @Blackwidow0307 หลายเดือนก่อน

    I have Premier 12 and I was ecstatic that I did the bat workaround...but I still have the Initialisation Error - wah wah wah wah

  • @beavisj75
    @beavisj75 หลายเดือนก่อน

    I do love a youtube fix that actually works. Thanks heaps.

  • @kpopstarx
    @kpopstarx 2 หลายเดือนก่อน

    what will happen if u forget to take back up

  • @philipwest4342
    @philipwest4342 2 หลายเดือนก่อน

    Thank you! Your advice about making sure the right name was in the client name´s field was critical. I was stuck because I wasn´t able to apply the credit to an existing invoice.

  • @GraemeHarker-h5y
    @GraemeHarker-h5y 2 หลายเดือนก่อน

    Xero UK only allows a payroll deduction to be booked to a "liability" account - Xero Oz seems to let you book the deduction to any account

  • @Jarod-z3f
    @Jarod-z3f 2 หลายเดือนก่อน

    Is this process the same for Brand new and 2nd hand vehicles?

  • @iam.SunilKumar
    @iam.SunilKumar 2 หลายเดือนก่อน

    This is old shchool and old video need to be updated, reconcile using bank feeds : can't find that video. should have link in this discription

  • @dominiquecarlson5108
    @dominiquecarlson5108 3 หลายเดือนก่อน

    Unfortunately I applied the overpayment to an expense account. Now that I'm reconciling the bank account, I am stuck with an expense that causes the bank account to not balance. This overpayment was part of a group of invoices paid by one customer. How do I go back to fix this without deleting the entire group of invoices and starting over? This is payment from 2023 and we're just now reconciling our accounts. 😵‍💫

  • @MaricelN-y1t
    @MaricelN-y1t 3 หลายเดือนก่อน

    So timely!!! Thanks a lot for this.

  • @ShenaLatha
    @ShenaLatha 3 หลายเดือนก่อน

    thank you so much

  • @megsimillion
    @megsimillion 3 หลายเดือนก่อน

    Thank you!

  • @fbkeene
    @fbkeene 3 หลายเดือนก่อน

    thanks a lot very simple and understandable

  • @hummycarton
    @hummycarton 3 หลายเดือนก่อน

    Really good video. Thank you from the UK :)

  • @AccountsCeramicPro
    @AccountsCeramicPro 3 หลายเดือนก่อน

    Thank you. The best Xero video I so far

  • @eishsandhu7153
    @eishsandhu7153 3 หลายเดือนก่อน

    You're a life saver, am a small business owner who does my own accounting and your videos are very helpful, especially for doing tax reporting. I appreciate you mate, thanks for doing this!

  • @alfiadipalma6276
    @alfiadipalma6276 4 หลายเดือนก่อน

    Thank You - worked

  • @user-jl2ss9tk9f
    @user-jl2ss9tk9f 4 หลายเดือนก่อน

    Thank you!! Worked perfectly to fix the same issue encountered after installing MYOB v18 on a PC running Windows 10 :-) You are a superstar!

  • @wendyyuen9922
    @wendyyuen9922 4 หลายเดือนก่อน

    Can you please tell us how to book fixed asset register with car limit ( if the car is over car limit) and the GST implication.

  • @VikkersOlfsson
    @VikkersOlfsson 4 หลายเดือนก่อน

    This saved my bacon this morning, thank you, legend.

  • @junekenshin8420
    @junekenshin8420 4 หลายเดือนก่อน

    Thank you very much for your explanation, this is very clear and easy to understand. Besides the vehicle, I find that Xero automatically listed the "Non-GST portion" as unregistered Fixed Assets (in the Draft tab). Should I register this as an asset without depreciation, or should I do something differently? Thanks!

  • @DKSYD0099
    @DKSYD0099 4 หลายเดือนก่อน

    Hi, how do we process PPL when the dates go into the new financial year and the daily rate changes?

  • @helenburman5463
    @helenburman5463 4 หลายเดือนก่อน

    Thank you!!!! I didnt know what to do when I couldnt open my file.

  • @leilanipower2435
    @leilanipower2435 5 หลายเดือนก่อน

    Absolutely a life saver!! Thank you. Worked perfectly

  • @GetMyCare
    @GetMyCare 5 หลายเดือนก่อน

    Thank you for explaining, MYOB need to work hard on their UI/UX modules! comparing it to other software

  • @lucindastratton6023
    @lucindastratton6023 5 หลายเดือนก่อน

    Thanks for that. Just wondering why the total super at the top of the screen doesn't reflect the extra 450? I'm trying to do similar and when I go to payroll super to add a payment, the extra RESC amount does not appear. Any suggestions?

  • @soniagreco9364
    @soniagreco9364 5 หลายเดือนก่อน

    Great video

  • @DeborahMatthews-kn6sv
    @DeborahMatthews-kn6sv 5 หลายเดือนก่อน

    great detail .... can I ask a Q about general receipting in Xero. Client marks as paid, I reconcile later. Does the payment need to be marked against invoice first or can it simply be done at reconciliation stage. Seems like a double entry. Is that right. In other software, you to create a receipt/deposit first, then reconcile, but it looks like Xero is different. or am I missing something in the process? Would appreciate some clarification thankyou.

  • @yvonnebebbington8221
    @yvonnebebbington8221 5 หลายเดือนก่อน

    So greatful for your help. Thank you!

  • @mohamadelias9693
    @mohamadelias9693 6 หลายเดือนก่อน

    Great explanation, very simple to understand. Please keep creating valuable informative videos.

  • @yourosew
    @yourosew 6 หลายเดือนก่อน

    Thankyou so muchh it really works

  • @LoWangSmg
    @LoWangSmg 6 หลายเดือนก่อน

    Sweet, I understand it finally ! Thanks Bro ! Would like to see how to salary sacrafice on a car and laptop or general living expenses.

  • @seukkaseukka1765
    @seukkaseukka1765 6 หลายเดือนก่อน

    thankyou, it works

  • @Spring4life-i3e
    @Spring4life-i3e 6 หลายเดือนก่อน

    Can you show how to reverse as now with STP you can’t delete pay run only reverse thanks

  • @Insight-.-
    @Insight-.- 6 หลายเดือนก่อน

    How to reconcile a past overpayment, that was two different invoices paid twice, under reconciliation. They have issued a bank payment with 1 refund line in two different batch payments

  • @MurrayShields
    @MurrayShields 6 หลายเดือนก่อน

    Thank you this worked great saved me

  • @marcrawley6001
    @marcrawley6001 6 หลายเดือนก่อน

    I want to create an aba file, how can I do this?

  • @PaulM-je8oe
    @PaulM-je8oe 6 หลายเดือนก่อน

    Thanks, great vid.

  • @Gener1KGaming
    @Gener1KGaming 7 หลายเดือนก่อน

    For anyone watching this video: 1:25 - Paid Parental Leave is 100% reportable as W1 on Activity Statements 7:55 - Since you'll be receiving the funds before you're paying your employee, Paid Parental Leave funds should NOT be assigned as revenue. Quote from Services Australia • Paid Parental Leave scheme Employer Toolkit: In accordance with Australian Accounting Standards, you must treat Paid Parental Leave funds you get from us as a liability. This is until you have provided Parental Leave Pay to your employee. You shouldn’t account for Paid Parental Leave funds as revenue or Parental Leave Pay as an expense.

  • @megaiang8133
    @megaiang8133 7 หลายเดือนก่อน

    Thanks a lot! Was looking for a reference to update my purchase which is not gst registered but unlike MYOB, Xero doesnot have the Not registrered option.

  • @Firemaker_Stoves
    @Firemaker_Stoves 7 หลายเดือนก่อน

    What you're looking for starts at 4:15