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.

Custom Fields in QuickBooks Desktop

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.

When you pay a bill in your business, are you 100 percent comfortable that the bill payment is correct and justified? Is there ever a chance that that bill is fake or fraudulent? What about duplicates? With so many fake bills being mailed to businesses these days, it makes sense to think about controls you can put into place to reduce the risk that you might write a check out of your hard-earned profits that should never be written.

Accounts Payable Controls

In the accounting profession, the term “internal controls” refers to processes, procedures, and automations you can put into place to reduce errors. In accounts payable, there is a specific subset of rules and controls you can put into place to reduce risk in this area. Here are just a few ideas.

1. Approvals

All bills should be approved by the appropriate level of employee in your business. Sometimes a bill gets approved that is fake or shouldn’t be approved, especially in areas where the approver doesn’t have technical knowledge of what they are buying. Be sure to read the fine print on the bill and make sure you know what you are paying for. There are ways to streamline the approvals process.

2. Segregation of duties

The person who pays the bill should be different from the person who submitted the bill. These people should be different from the one who signs the check. This reduces employee fraud.

3. Receipt confirmation

A packing slip or other confirmation of receipt of the goods or services should be matched to the bill, line item by line item.

4. Math check

A prudent step is to check a bill’s math, at least for reasonableness.

5. Duplicate payments

If a vendor emails their bill as well as mails a hard copy, controls should be put in place (usually automated) to avoid duplicate payments on the same bill.

6. Reconciliation

If there are a significant number of transactions between you and a vendor, an accounts payable reconciliation should be performed each month via a statement.

7. Missing check numbers

Most systems provide a missing check numbers report that you can use to make sure all checks are accounted for.

8. Bank reconciliation

A bank reconciliation is a sure way to see exactly what checks cleared your bank account.

9. Coding

Coding each transaction to the correct expense account, inventory, asset, or cost of goods sold account is an essential part of the process.

10. Income statement review

Each month, a review of the balances in your expense accounts as well as a disbursements ledger review for reasonableness can provide added peace of mind.

11. Purchase order

Requiring purchase orders is another control you can add to your process. Purchase orders should be matched to packing slips and bills before payment or approvals are made.

12. In-depth knowledge of your business’s numbers

The more you get to know the numbers in your business, the greater chance you’ll have of accurate accounts payable handling.

If you’d like to discuss your accounts payable function with us and how it can be improved and streamlined, we’re happy for you to reach out any time.