Before you begin - Before you start the bank account setup, verify that you have your accounts set up in General Ledger.
- Create new bank accounts before entering transactions, when possible. It's simplest to create the bank when it has balances of zero.
- We recommend using Setup Assistant to create your Cash Management bank accounts.
- For help on an item in the Setup Assistant windows, right-click the item and select What's This?
Setting up the account - Go to Cash Management, Setup, Setup Assistant.
- Follow the steps below to complete the bank setup. Each section below corresponds to a separate screen in the setup wizard.
Introduction Review the introduction and click Next. Specify CM Settings - Click CM Settings to review your Cash Management settings.
- Click OK and then click Next.
Set up Bank Accounts - Click Bank Account to open the Bank Accounts window.
- If you already created this account, select it from the Bank account list and skip to step 5. If this is a new bank account, click the button with the * (asterisk).
- Type a bank account ID (up to 10 characters) for the new bank account and then click Insert. If you use AvidXchange, don’t use commas, spaces, dashes, periods, or other special characters for your ID.
- Enter the full name of your bank account or a description in the Description box.
- Select the GL Cash Accounts tab.
- From the General cash account list, select the cash account that you want to use for this bank.
- Select the checkboxes corresponding to each of the interfacing applications that want to use this bank account.
- To use separate cash accounts for each application, select the Use separate cash accounts per application box. You can then specify a specific full or base account to use with your interfacing applications. The General cash account is the only box that requires entry before continuing through Setup Assistant.
- You can enter more information on the bank now, or enter the information later in Setup, Bank Accounts.
- If Accounts Payable (AP) or Payroll (PR) will be using this bank account, go to the General tab. Select the AP check format and/or PR check format to use with this bank.
- Click Close to return to the Setup Assistant process.
- Click Next.
Select Bank Account Select your new bank account and click Next. Enter Balances For Cash Management to report accurate bank account balances, each bank must "Go Live" with a beginning balance as of a specified time. Setup Assistant walks you through the process to set up Cash Management and establishes the beginning balance and starting point for the bank account. Balances entered directly to Cash Management must correspond with the future balances of the cash accounts in General Ledger. - Locate the statement ending balance on the most recent bank statement you have for this bank. Enter that amount in the Last statement ending balance box (unless the GL future balance is $0.00). If the account doesn’t have a balance, enter 0.00. New banks have a 0.00 last statement ending balance because transactions don't appear until the next statement.
- Enter the date of your most recent bank statement in the Last statement date box. If this is a new account, use the date you opened the account as the last statement date.
- Leave the prefilled General cash account.
- In the Cash Account column, enter each cash account associated with the bank. Include the same cash account that appears in the General cash account box above.
- Enter the General Ledger future balance for each cash account in the Amount column. If this bank replaces an existing CM bank and will use the same GL account, enter 0.00 instead. After going live on this bank, enter a bank transfer in Cash Management. Move the balance from the existing bank to this new bank account. You can find the future balance in the General Ledger Account inquiry.
- In General Ledger, from the Inquiry menu, select Account.
- Select Current, and then click OK.
- Note the appropriate Future Balance.
- Click Next.
Enter Open Transactions - Enter your open transactions. Only enter transactions already accounted for in General Ledger. Entering your Open Transactions doesn't send entries to General Ledger.
- Cash transactions already entered to this bank account from other applications appear here. If you have never used this bank account in any other application, no transactions appear.
- Click Next.
Go Live Select Yes under Do you want to go live with bank account "<bank account ID>"? if: Last Statement ending balance (Enter Balances, step 1) + Open Transactions (Enter Open Transactions) = General Ledger Future Balance (Enter Balances, step 5) The Go Live option is only available if the bank account is in balance with General Ledger. If Yes is unavailable, your bank account isn’t in balance with General Ledger. More information For more information about setting up or changing the bank accounts in other modules, refer to the following articles. Sage MyAssistant can notify your admin users when a user creates a new account. This ensures that the right people in your organization are aware of these types of changes. Contact our Sales team at 1-800-858-7095 for more information on how Sage MyAssistant can help your business. |