top of page

Acumatica Finance: Cash Management

Overview: Cash Flow Management

​

Cash Flow Management is available right from a dashboard for the CFO, Controller or Accountant. It enables you to do the following items:

  • See the cash on hand as of today across all bank accounts

  • See the Accounts Receivables for the next months, and be able to drill down to certain customers to see how much their outstanding dues are, and why.

  • See the Accounts Payables for the next month, and be able to drill down to certain vendors/suppliers to see how much you owe them, when you owe them certain amounts, and why.

  • Soon you will be able to see the projected net cash flow (cash on hand + AR - AP) for the next weeks and months so that you can take actions to avoid a cash crisis.

The next video illustrates this Cash Flow Management feature:​

Important features of cash management or banking

  • Lesson 5: Specifying cash managment preferences.

  • Lesson 8: How to modify a payment method such as check, ACH, credit/debit card, ...

  • Lesson 6: How to create an entry type

  1. Group accounts Eg. cash accounts or AR accounts or AP accounts

  2. Specify a template for GL transactions for that group and specify:

    1. Debit GL account

    2. Credit GL account

  • Lesson 9: How to define credit terms

  • Importing a bank statement, and reconciling it with our booked bank transactions

    • Importing a bank statement is easily done in Acumatica since Acumatica supports the Open Finance Exchange (OFX) file format.

    • Video (3 mins, 2016) on the left. Video (8 mins, 4/2020) on the right.

  • Reconciling the imported bank statement with our booked bank transactions

    • Acumatica automatically lists the booked bank transactions that have not been reconciled yet with transactions in the bank statement. A very smart matching algorithm is used to identify the matching transactions so that reconciliation becomes very easy.

    • Bank reconciilation only works when your bank can feed your company with bank transactions. 

    • If a bank transaction in a bank statement has no description, you can let Acumatica automatically create a bank transaction

    • Bank reconciliation is done for only checking and savings accounts since banks give only feeds for such accounts. Petty Cash and Cash in Transit, and Credit Cards to pay vendors, are not reconciled. 

    • Video (6 mins, 2016)

  • Bank deposit process

    • When checks are deposited into a checking or savings account, it may take one or more days before they are cleared and appear in the bank account. Therefore such deposits are deposited in a temporary deposit account.  

    • Acumatica enables you to specify per customer or per customer class such a temporary deposit account so that when a customer payment is made, the customer payment booking goes automatically to the temporary deposit account.

    • Video (6 mins, 2014)

  • Credit card processing

    • Acumatica enables you to process customer credit card payments via a token, which is PCI compliant and makes it very secure. This way credit card information is not stored in the Acumatica database. Authorize.Net is already built into the Acumatica bank/cash management module.

    • To process credit card payments with other payment processors, there are several Independent Software Vendor (ISV) applications that are 100% integrated with Acumatica. There is no fee for the ISV application software but, there is a CC transaction fee.

    • Corporate credit card transactions enable your employees to charge their corporate credit card, and enable your accountant to book those charges as expenses against the corporate credit card account of a certain employee. 

Video (6 mins, 2016)

Video (15 mins, April, 2020) shows new features such as corporate credit cards and Fedwire.

  • Paying vendors via ACH (aka Electronic Funds Transfer (EFT) )

    • Acumatica enables to use ACH as a payment method, and to specify the beneficiary name, bank routing number and bank account number​

    • You can select this ACH payment method for any vendor

    • You can gather all these ACH payments in a batch file, and email that batch file to your bank for processing the wire transfer

    • Video (4 mins)

  • Field level auditing

    • Acumatica enables you to audit any field in any screen or document. Any changes to an audit enabled field will be tracked securely. This way your ERP will comply with the Sarbanes-Oxley requirements.

    • Video (6 mins, 2014)

Other important Features of Cash Management Software 

 

  • Petty Cash Management 

    • Manage petty cash and bank account balances quickly and easily. View transaction history for a specific date range and switch between detailed and daily views. Trace both uncleared and cleared balances, and clear and add cash related transactions directly from the inquiry screen. 

  • Remittance and Payment Instructions 

    • Gather and pre-define payment information (preferred payment type, account numbers) for vendors and customers to simplify and speed up payment processing. 

  • Processing Centers 

    • Configure the processing centers you will use for cash collection and associate customer payment methods with a particular processing center – used for automated credit card processing. 

  • Multiple Currencies Support 

    • Maintain cash account balances in your base currency and your bank account currency. Execute cash revaluation to reflect rate changes. Automatically calculate realized gain and loss when transferring funds between accounts using different currencies. More

  • Cash Account Security 

    • Control access to cash account information and balances to prevent unauthorized access and restrict sensitive company information. 

  • Cash Account Reporting 

    • Use provided reports to reconcile cash accounts balances and manage short-term cash reserves as well as forecasts and projections. Drill down to review transaction details. 

  • Audit Trail 

    • Maintain a complete audit trail of all cash-related transactions. Transaction records cannot be changed – corrections are handled through adjusting entries, which are logged. The cash management system captures the ID of the user who entered the transaction or adjustment. Attach notes and supporting electronic documents directly to transactions. 

 

Key Benefits of Cash Management Solutions for Your Company 

 

  • Integrate with Financial Modules 

    • Automatically collect all cash account transactions from General Ledger, Accounts Payable, and Accounts Receivable into Cash Management for clearing and reconciliation. Transactions linked to a vendor or customer automatically create entries in Accounts Payable or Accounts Receivable and update appropriate balances. 

  • Transfer Funds Between Cash Accounts 

    • Transfer funds between bank accounts and track funds that are in-transit. Transfer between accounts in different currencies, and automatically calculate realized currency gains or losses. 

  • Streamline Bank Account Reconciliation 

    • Simplify the reconciliation process. Add bank charges and bank interest, and record any omitted cash directly from the reconciliation screen. 

 

Data Sheet Cash Management:

bottom of page