Learn about the Audit Trail Feature in QuickBooks Desktop and Online from Rhonda Rosand, CPA from New Business Directions, LLC.
The Audit Trail tracks the who did what when: it tracks the history of a transaction, where it started, what changes were made and what it looks like now. This tool can be especially useful to accountants.
This is a great video to help you understand and gain control over your A/P process:
Five Common Accounts Payable Errors
Paying bills might not be fun, but paying bills you shouldn’t pay or have already paid in the first place is even worse. There are many risks that can part a small business owner with their hard-earned cash, and here are five to watch out for when it comes to your bill-paying process.
- Fraudulent invoices
Some companies will send marketing documents disguised as invoices to businesses. You may have to read the fine print to notice it’s not really an invoice. In some cases, it’s simply outright fraud, trying to get you to pay something that is not owed.
Many times, these invoices look official, similar to legal filing requirements, but don’t be fooled. Examination of the fine print can save you a lot of money.
Set up procedures to catch these types of invoices. Managers should be careful not to approve these invoices for payment. Bookkeepers should be trained to question their supervisors about these invoices.
- Item(s) not received
Three-way matching can prevent paying an invoice for which the goods were never received. Put into place a couple of procedures to prevent this accounts-payable error:
- Have warehouse staff match the shipping receipt to what’s in the shipment when it arrives.
- Have accounts payable staff match the marked-up shipping receipt to the invoice when it comes in. If the invoice shows that more items were billed for than received, a call to the vendor to correct the invoice is in order. The invoice amount should be adjusted on the books and a check can be cut for the reduced amount.
- Wrong amount
Sometimes the wrong price can be listed on the invoice. If this happens, there may have been a misunderstanding during the sales process. A call to the vendor is needed in this case as well so that a corrected invoice can be issued.
- Math error
This hardly happens in these days of computers, but it can. All invoices should be reviewed for reasonableness. If it doesn’t make sense that something should cost so much, it probably shouldn’t. In rare cases, a price may have been entered wrong or a computer bug could have occurred.
Spot-checking the invoice’s math can save money if an error has been made.
- Duplicate invoice
This happens way too often. We may get an emailed invoice; then the same invoice comes in the mail. We need procedures in place to keep it from being paid twice.
Many accounting systems do this automatically, but if one character is off related to vendor name, or if the invoice number is off, the system could break down. Review a list of disbursements monthly to make sure payments don’t get duplicated.
Procedures are the answer to reducing accounts payable errors and making sure you pay only the invoices that are truly due.
If you need help putting procedures in place for accounts payable, please reach out – we’re happy to help.
Join Rhonda Rosand, CPA and Advanced Certified QuickBooks ProAdvisor of New Business Directions, LLC, and learn how to Record PPP or EID Loans in QuickBooks Desktop and QuickBooks Online:
Here Rhonda’s latest video on how to add multiple users in you QuickBooks Desktop file:
Here is how to add users in your QuickBooks Online file:
Custom fields in your accounting software are data fields that you can define yourself. They are typically associated with customers, vendors, employees, and items, and they can help you store and categorize additional information about these stakeholders and your products and services in your business.
An example custom field that can be associated with customers is their anniversary date with you. You could also decide to store their birthday, their spouse’s name, their favorite color, or their shoe size.
Custom fields add functionality to your accounting system. Here are a few examples of practical uses for custom fields:
- Contact for customer – if customers are assigned a particular team member, you can add their name in a custom field
- Frequency of service – daily, weekly, monthly
- Warehouse location
- Type of customer; for example, non-profit, construction, retail, restaurant
- Referral Source
- Preferred method of contact: email, phone, fax, text, chat
- License number
Our customer custom fields track which version of QuickBooks you use, what payroll service is active, who your tax preparer is, etc. Then we can sort on any one of these fields.
Some software allows you to choose the type of custom field you want to add. In some cases, this allows for cleaner data as the data can be limited to a certain type or certain values upon entry. Here are the most common types:
- Free form text – this is the default type; it can come as a single line or paragraph
- Check box – choose one or more values from a limited number of choices
- Radio button – choose only one value from a limited number of choices
- Drop down – choose a value from a dropdown list
- File upload – add an attachment
- Image upload – upload an image that will be displayed
- Date/time – enter a date or time
- Number – enter a number; it can be currency, integer, or another mathematical type of number
Custom fields allow you to meet your company’s unique needs over and above what the software provides by default. It’s a great way to make your data more meaningful. If you have some ideas for custom fields in your accounting software and want help setting them up, feel free to give us a call anytime.
Nobody likes, them, but sometimes it happens. This is how you record it in QuickBooks if this happens to you.
Learn How to Record a Bounced Check From a Customer in QuickBooks® with Rhonda Rosand, CPA and QuickBooks® ProAdvisor from New Business Directions, LLC
If you want to swap services with a vendor or customer, great! But did you know barter transactions are taxable, and they need to be recorded on your books. Here’s a video from Rhonda on exactly how to record barter transactions: https://www.youtube.com/watch?v=iOAaOrojGhI
Learn How to Use the Same Name on Different Lists in QuickBooks with Rhonda Rosand, CPA of New Business Directions, LLC.
A great way to make a wonderful start to 2020 is to wrap up 2019 feeling organized and on top of the world. Here’s a checklist of items that you can start on now to make your year-end close go smoother than ever before. And don’t worry if you don’t know how to do some of these tasks – that’s what we’re here for.
- Catch up on your books, especially if you do them only once a year. By doing it now, you’ll be able to get into your accountant faster this time of year and they will appreciate getting the work done ahead of their crunch time.
- Catch up on bank reconciliations in case they are not up to date. Don’t forget your savings accounts, PayPal, and any other cash equivalents. Void any old uncleared checks if needed.
- Review unpaid invoices in accounts receivable and get aggressive about collecting them, especially if you are a cash basis tax payer. Clean up any items that are incorrect so that the account reconciles.
- Write off any invoices that are no longer collectible.
- Ask employees and vendors to update their addresses in your payroll system so that W-2s and 1099s will reflect the correct addresses.
- Collect any W-9s that you don’t already have on file for contractors that will receive a 1099 form from you.
- Collect workers compensation proof of insurance certificates from contractors so you won’t have to pay workers comp on payments you have made to them.
- Collect sales tax exemption certificates from any vendor who has not paid sales tax.
- Decide if you’ll pay employee bonuses prior to year-end. Reminder: This payroll is subject to withholding taxes.
- Review employee PTO and vacation time and reset or rollover the days in your payroll system.
- After the final payroll runs, contact your payroll software company to make any W-2 adjustments necessary for things like health insurance.
- Set the date to take inventory, and once you have, make adjustments to your books as necessary.
- Write off any inventory that is unsalable. If possible, sell scrap inventory or other waste components.
- Prepare a fixed assets register, calculate depreciation, and make book adjustments as needed. Leave the calculations and adjustments to us or your tax preparer.
- Record all bills due through year-end, and reconcile your accounts payable balance to these open bills.
- Make loan adjustments to reflect interest and principal allocations.
- Perform account analysis on all other balance sheet accounts to make sure all balances are correct and current.
- Make any additional accrual entries needed, or if you’re a cash basis taxpayer, make those adjustments as needed. You can leave these entries to your tax preparer.
- Get an idea of what your profit number will be. Choose whether you want to maximize deductions to save on taxes or whether to want to reflect more income. Decide what you can defer into 2020 or what you want to have as part of your 2019 results.
- Match all transactions with their corresponding documents – receipts, bills, packing slips, etc. – to make sure you have the paper trail you need. Go paperless – digitize these documents!
- Download your bank statements and store them in a safe place.
- Download any payroll reports and store them in a safe place.
- Scan in paper documents so that they’re stored electronically.
- File any important papers such as new leases, asset purchases, employee hiring contracts and other business contracts.
- Prepare a revenue and profit plan for 2020 and enter it into your accounting system.
- Take a look at the 2020 calendar to determine which holidays you’ll close and you’re your employees a copy of the schedule.
- Review your product and service prices if this is the time of year you do that and make any changes you decide on.
- Update your payroll system for any new unemployment insurance percentages received in a letter each year.
- Update the mileage deduction rate if that rate has changed at the beginning of the year.
- Set a time with your accountant to go over 2019 results and get ideas on how to meet your financial goals in 2020.
- Review the metrics you’ve been using in 2019 and decide on the list of metrics and corresponding values that will take you through 2020.
- Celebrate the new year; it’s a wonderful time to gain perspective and be hopeful about the upcoming year.
Start 2020 with a bang and this year-end checklist, and feel free to reach out if we can help with anything.