- 78
- 495 629
QTraining
Australia
เข้าร่วมเมื่อ 6 ก.พ. 2021
We are an office training firm that specialises in accounting software.
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
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 | How to Reverse a Supplier Payment
มุมมอง 2.4Kปีที่แล้ว
MYOB | How to Reverse a Supplier Payment
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
Process Annual Leave and Sick Leave in MYOB
มุมมอง 5Kปีที่แล้ว
Process Annual Leave and Sick Leave in MYOB
Thanks for video but I have to say wow! so manual. What a bad solution to anyone with more than a few employees.
Sir why it's not working on my laptop i've been trying many Times but it couldn't work
thank youuu sirr, you all the best ❤
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!
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.
Great explanation and easy to understand
Thankyou, very helpful. The help instructions in QBO do not explain it like this
Is this MYOB AccountRight Plus?
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.
i love you sir, i can do my assignment now :D
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
I do love a youtube fix that actually works. Thanks heaps.
what will happen if u forget to take back up
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.
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
Is this process the same for Brand new and 2nd hand vehicles?
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
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. 😵💫
So timely!!! Thanks a lot for this.
thank you so much
Thank you!
thanks a lot very simple and understandable
Really good video. Thank you from the UK :)
Thank you. The best Xero video I so far
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!
Thank You - worked
Thank you!! Worked perfectly to fix the same issue encountered after installing MYOB v18 on a PC running Windows 10 :-) You are a superstar!
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.
This saved my bacon this morning, thank you, legend.
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!
Hi, how do we process PPL when the dates go into the new financial year and the daily rate changes?
Thank you!!!! I didnt know what to do when I couldnt open my file.
Absolutely a life saver!! Thank you. Worked perfectly
Thank you for explaining, MYOB need to work hard on their UI/UX modules! comparing it to other software
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?
Great video
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.
So greatful for your help. Thank you!
Great explanation, very simple to understand. Please keep creating valuable informative videos.
Thankyou so muchh it really works
Sweet, I understand it finally ! Thanks Bro ! Would like to see how to salary sacrafice on a car and laptop or general living expenses.
thankyou, it works
Can you show how to reverse as now with STP you can’t delete pay run only reverse thanks
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
Thank you this worked great saved me
I want to create an aba file, how can I do this?
Thanks, great vid.
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.
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.
What you're looking for starts at 4:15