Blog Post

Managing Payables with Acumatica

Published on

April 1, 2020

By

by

Dana Zodrow

Managing accounts payable efficiently and effectively is a key component of any business, as it affects your company’s bottom line as well as its cash flow.  Acumatica eases the stress of managing payables by creating an easy process to follow.  Follow these steps to complete a payable cycle:

  1. Enter payables (“Bills and Adjustments”) into Acumatica:
  1. Click on “Payables.”
  2. Click on “New bill.”
  3. In “Type” box, select type of item you are entering by using the dropdown menu. Options include: Bill, Credit adjustment, Debit adjustment, Prepayment.
  4. Hit Tab or Enter to move to the “Date” field, and enter the date you want the bill to post to. For example, if your mortgage bill is dated February 25, but applies to your March payment, use “3/1/20” as the date in order to post the cost to the correct month.
  5. The “Post Period Date” will automatically generate according to the date entered in the step above.
  6. In “Vendor Ref” box, type in the vendor’s invoice number.
  7. In “Description” box, enter any relevant details about the invoice for your future reference. For example, for a mortgage bill, you might type in “Mortgage payment – March 2020.”
  8. In “Vendor”box, enter the appropriate vendor. There are a couple of ways to do so. You can type vendor name and choose correct vendor from the list that appears. You can also add a new vendor into the system from this screen by clicking on the pencil to the right of the vendor field.
  9. Enter “Location.” You can type in this box, or use the search icon.
  10. Enter “Terms.”
  11. The “Due Date”box will automatically populate according to the terms chosen in the previous step. If necessary, you can update or change the date that appears.
  12. Enter “Cash Discount Date” if applicable.
  13. Enter “Discount Total” if applicable
  14. In the “Amount” box, enter the total amount of the invoice (bill).
  15. Under the “Document Details” tab in the middle of the screen, use the “+” button to add lines. Choose the correct “Branch” (if more than one is available). Enter the “Inventory ID” (if applicable. Enter the “Quantity.” Enter the “Unit of measure.” Enter the “Transaction Description.” Enter the “Unit Cost.” The “Ext. Cost” box will automatically calculate based on quantity and unit cost; edit if necessary. In the “Account”box, enter the account code for cost. Enter “Sub-account”details if applicable.
  16. All other fields are dependent on your company, and only need to be entered if necessary to your company’s requirements.
  17. Once all required fields/lines are entered, attach any necessary documentation. Then, in the “Status” area in the top left portion of the screen, click the checkmark box next to “Hold,” so that the bill is in balanced mode.

Reviewing Balanced Payables

Balanced payables can be reviewed and released (posted) separately or all at once, depending on your preference. If reviewing and releasing separately, simply click on “Release” at the top of the page, and the bill’s status will change to “Open.” If releasing/posting all at once, follow these steps:

  1. On the Payables main screen, under “Processes,” click “Release AP Documents.”
  2. Click the box directly to the left of “Bill” ready for release/post.
  3. Click “Release” at the top of the screen.
  4. Click OK once the process is complete
  5. You can also click on “Release All” at the top (without using checkmarks) to release the entire list of payables.
  6. When ready to process/pay bills, complete the following steps:
  7. On the Payables main screen, under “Processes,” click “Approve Bills for Payment.”
  8. Choose your preferences at the top of the page regarding pay date within ____ days, due date within ____ days, or cash discount expiration dates.
  9. Click on the check box next to the Bill to approve bills for payment.
  10. Click on the “Save” icon (disk icon) at the top of the screen.

Processing Vendor Payments in Acumatica

To process payments, follow these steps:

  1. On the Payables main screen, under “Processes,” click on “Prepare Payments.”
  2. Choose “Payment Method.”
  3. Choose “Cash Account.”
  4. Verify “Payment Date” and “Post Period.”
  5. Click on the check box to the left of the Bill you would like to pay.
  6. Click “Process” at the top (Click “Process All” to pay all bills without using checkmarks).
  7. A new window will appear showing the next check number available, along with the payments ready to be created.
  8. Click “Print.” A new window will appear with PDF copies of the payments. Print the copies. Exit the window when complete.
  9. Click “Process” to post the payments to General Ledger.

A Quick Trick

Here is a tip I have found useful when processing payables.

Use the copy and paste function as often as possible. This will cut down on errors as well as save data entry time. For example, if AT&T provides your cell service, search for last month’s payable for AT&T.

  1. Under “Bills and Adjustments,” use the search feature to find the bill.
  2. Click on the bill to look at it.
  3. Click on the copy button at the top.
  4. Click the “+” icon.
  5. Click on the “Paste” button.
  6. Update necessary information.
  7. Save, balance, and release (if necessary).

Recurring Transactions

Use “Generate Recurring Transactions” so that you never forget a bill.

For example: Does the credit card company charge you the same amount automatically each month? Here’s how to generate a recurring transaction.

  1. Once you have created the payable, click on “Actions.”
  2. Click on “Add to Schedule.”
  3. Update all necessary information, and choose the date you would like the payable to run each month.
  4. Set a reminder to run the payable (or set it up to auto run each month).

Let Acumatica do the hard work for you!



Written By
Website Proudly Crafted by DSB Creative