Page tree

 

Reconciled checks display in bank reconciliation. How do I get rid of them?


To remove these checks from Bank Reconciliation, you must reconcile them outside of Bank Reconciliation.

 To reconcile checks in General Ledger
  1. In Bank Reconciliation, do not mark the check for reconciliation.
  2. Click Save to close Bank Reconciliation.
  3. On the G/L Posting Menu, click Add/Edit Transactions, then View.
  4. Click Find Transaction .
  5. On the Text Search tab, select Ref. No.
  6. Enter the check number and click Find Text.
  7. When the Search Results display, double-click on the check. The Add/Edit Transactions list displays with the check selected.
  8. Select Reconciled. When you return to the bank reconciliation window, the check does not display.

 

Return to top

 

How do I transfer funds from one bank account to another so transactions display in Bank Reconciliation?


When you move funds from one bank account to another, you must use the Bank Transfer option so the entries display in Bank Reconciliation. This function splits the transaction into two transactions: a withdrawal and a deposit. The withdrawal displays in Bank Reconciliation for the account the money is taken from; the deposit displays in Bank Reconciliation for the account the money is deposited into.

 To transfer funds between bank accounts
  1. Under Manage Records, click the Transactions tab.
  2. In the drop-down list, select General Ledger Transactions and click Go .
  3. Click Add/Edit Transactions, then click Bank Transfer.
  4. Enter a reference number or click Next to auto-assign the available reference number for the Transaction Source (Bank Account Transfer).
  5. Enter the amount of the funds transfer, then enter or select the date of the funds transfer.
  6. On the Transfer tab, in the Credit Acct field, enter the general ledger account number that will decrease. ACS deducts the funds from this account.
  7. Optional: In the For field, enter an explanation.
  8. In the Offset field, enter the general ledger transfer account number. If you do not have a transfer account in your chart of accounts, use the fund principal account for the credit account.
  9. In the Debit Acct field, enter the general ledger account number that will increase. ACS adds the funds to this account.
  10. Optional: In the For field, enter an explanation.
  11. In the Offset field, enter the general ledger transfer account number. If you do not have a transfer account in your chart of accounts, use the fund principal account for the debit account.
  12. Click OK, then Close.
  13. Print the Proof List report.
  14. Click Begin Post.
  15. Click Yes, OK, and Close.

Return to top

 

I added a new expense account to my chart of accounts, but it does not display on the Analysis of Revenues and Expenses report.


When you add an account to your chart of accounts, you must select the heading you want the account to display under before clicking Add Account. If the account is active with a balance for the month, it displays on your printed report appropriately. If the account does not display in the correct place on the report, the account was added under the wrong heading.

If no transactions are posted to the account, you can move the account to the correct location in the chart of accounts.

 

 To move an account
  1. Under Manage Records, click the Chart of Accounts tab.
  2. In the drop-down list, select Add/Edit Chart of Accounts and click Go .
  3. Select the account you want to move, then click Move Account.
  4. Select the heading under which the account should display.
  5. Click OK.

You can also drag and drop an account from one heading to another.

Note

If transactions are posted to the account, you must move the account within the same account type. For example, you can move an expense account to any subheading in the Expenses account type, but you cannot move an expense account to a subheading in the Liabilities account type.

If the account is under the wrong account type and transactions are posted to it, you cannot move it. You must add the account under the correct heading. However, you must first change the account number and description under the present heading so you can add the present account number under the correct heading.

 To add an account with transactions to another heading
  1. Under Manage Records, click the Chart of Accounts tab.
  2. In the drop-down list, select Add/Edit Chart of Accounts, and click Go .
  3. Select the account under its present heading, and click Edit Account.
  4. Enter a new account code. We suggest choosing an account code you will not use, such as all nines (9-999999, 0099999, or similar to fit your account mask).
  5. In the Name field, enter a new description to indicate that this is no longer a valid account, then click OK.
  6. Select the correct account heading and click Add Account.
  7. Enter the original account code and account name.
  8. Select the fund and any other options that apply to the account, then click OK.

Once the account is added under the correct heading, you must move the balance of the account from the original account to the new account. You cannot move the transactions, only the balance. You can enter a transaction and post it to move the balance.

When you move the balance of the account, you debit one account and credit another account. The account type of the two accounts determines which account is debited and which account is credited. Refer to the following table to determine the correct balance type for each account type. When you want to reduce the balance in one account to zero ($0.00), enter the balance amount as the opposite of its correct balance type.

For example, an expense account has a balance of $250.00. The account should be a liability account. After adding the account with transactions to another heading, you want to move the balance. Enter a transaction to credit the “old” account because the expense account has a debit balance, then credit the new account because liability accounts carry a credit balance. To balance this transaction, enter a debit amount equal to the amount of the two credits. Use the fund principal account because you have no other account involved in this transaction. However, if you have two accounts to which you enter a debit amount and a credit amount that are equal, do not make any other entries because the transaction is balanced.

Asset Type

Balance Type

Assets

Debit

Liabilities

Credit

Fund Principal

Credit

Revenues

Credit

Expenses

Debit

Other Revenues

Credit

Other Expenses

Debit

Temporary Restricted

Credit

Permanent Restricted

Credit

 To move the balance from one account to another

 

  1. Under Manage Records, click the Transactions tab.
  2. In the drop-down list, select General Ledger Transactions and click Go .
  3. Click Add/Edit Transactions, then Add.
  4. In the Transaction Source drop-down list, select Journal Entry (JRE).
  5. Verify the posting period is correct. If necessary, edit the Month or Year field to change the posting period.
  6. Under Transaction Entries, click Next, or enter a reference number.
  7. Enter a date, or press Enter to accept the current date.
  8. Optional: Enter an explanation.
  9. Click inside the Transaction Entries grid and enter the old general ledger account number. This is the account number when adding an account with transactions to another heading.
  10. Enter the balance in the correct Debit or Credit field, and press Enter.
  11. Optional: Enter a comment.
  12. Optional: Click in the Project column and select a project code from the drop-down list.
  13. Enter the new general ledger account number.
  14. Enter the balance in the correct Debit or Credit field, and press Enter.
  15. Optional: Enter a comment.
 To print the Proof List
  1. On the G/L Posting Menu, click Preview.
  2. When the Proof List displays, click Print , then Close.
 To post the transaction
  1. On the G/L Posting Menu, click Post Transactions.
  2. In the Posting Period dialog box, make the selections that you want.
  3. Click Begin Post, then Yes.
  4. Click OK, then Close.

Return to top

 

How do I delete accounts that are no longer in use?


If an account has no transactions posted to it, you can delete the account at any time. However, because you can print ACS reports for a previous month or year, you cannot delete accounts that have transactions associated with them. This rule keeps reports in balance. Even if the balance in the account is zero ($0.00), ACS keeps track of when transactions were posted to the account.

You can summarize accounts to remove the transaction detail for any years except the current year and the year immediately preceding the current year. ACS considers the active posting year in your ACS system, not the current calendar year, as the current year. By summarizing your data, ACS removes the transaction detail from your data files up to the year you select. Transaction detail is retained for the current year and the previous year.

For example, your current posting year in ACS is 2011. If you summarize your data through 2009, all transaction detail in accounts with a balance of $0.00 is removed for any year before the year 2010. All detail for the years 2010 and 2011 is retained for reporting purposes.

Warning

Before summarizing your data, ACS Technologies recommends creating an archived dataset. Creating an archived dataset lets you review the details of the years that you have summarized. Without an archived dataset, you cannot view transactions or accounts for summarized years.

After you archive and summarize your data, you can delete any accounts with a balance of $0.00 that no longer have transaction details attached to them.

 To archive your data
  1. Under Manage Records, click the Period End Procedures tab.
  2. Select Archive Financial Data, and click Go .
  3. Click Yes.
  4. Enter a name for the archived dataset. For example: 2011 Church of Good Training History File. Click OK.
  5. After the files copy, a confirmation message displays. Click OK.
 To open an archived dataset
  1. Under Advanced Tools, click the Admin Utilities tab.
  2. Click Select Dataset, and click Go .
  3. Select Include Archived Datasets, then select the archived dataset.
  4. Click OK.

Return to top

 

How do I display the columns I want on the Analysis of Revenue and Expenses report?


The Analysis of Revenues and Expenses report is a versatile report that lets you choose the columns that display on the report. You can rename the columns and add a blank column.

The Analysis of Revenues and Expenses report only displays accounts that are classified as revenue or expense account types. Accounts that are classified as assets, liabilities, or restricted accounts do not display on the report.

 To format the Analysis of Revenues and Expenses report
  1. Under Generate Reports, click the Reports tab.
  2. In the drop-down list, select General Ledger, and click Go .
  3. Under Financial Reports, expand Statements, then select the Analysis of Revenues & Expenses report (Detail or Summary).
  4. Click Customize.
  5. On the Options tab, click Setup Columns.
  6. Use the arrow to select the columns to display on the report. To see all available options, expand the field name menus under Available Fields. You can also remove columns from the report.
  7. Once all columns you want to include are located under Columns to Include, you can rename them or reposition them so that the columns display in a different order.
  8. When finished, click OK.
  9. Click Preview or Print.
  10. Click Close.

You can save the report as a public report so that others can view or print the report. If you do not save the report as a public report, only you can view or print the saved report.

 To rename a column heading on the Analysis of Revenues and Expenses report
  1. Under Generate Reports, click the Reports tab.
  2. In the drop-down list, select General Ledger and click Go .
  3. Under Financial Reports, expand Statements, then select the Analysis of Revenues & Expenses report (Detail or Summary).
  4. Click Customize.
  5. On the Options tab, click Setup Columns.
  6. Use the arrows to select the columns to display on the report. To see all available options, expand the field name menus under Available Fields. You can also remove columns from the report.
  7. Under Columns to Include, select the column heading that you want to rename. The column heading displays under Column Settings.
  8. In the Heading field, enter the new column heading. (The new column heading does not display under Columns to Include.)
  9. When finished, click OK.
 To reposition columns on the report
  1. Under Generate Reports, click the Reports tab.
  2. In the drop-down list, select General Ledger and click Go .
  3. Under Financial Reports, expand Statements, then select the Analysis of Revenues & Expenses report (Detail or Summary).
  4. Click Customize.
  5. On the Options tab, click Setup Columns.
  6. Use the arrows to select the columns to display on the report. To see all available options, expand the field name menus under Available Fields. You can also remove columns from the report.
  7. Under Columns to Include, select the column heading that you want to reposition. To move the column heading farther left on the report, click the up arrow . To move the column heading farther right on the report, click the down arrow .
  8. When finished, click OK.

Return to top

 

I opened a new checking account at the bank. How do I set this up in ACS so that it displays as a checking account?


To post transactions or perform bank reconciliation on an account, you must set it up in ACS.

The first step is to add a new bank account in Define Lists. Then, you can add the general ledger checking account in your chart of accounts and attach the new bank account to the checking account. By adding the new bank account, the ACS bank reconciliation process only includes transactions for this bank account, which many users find much easier when reconciling a new account.

 To add a new bank account
  1. Under Advanced Tools, click the Define Lists tab.
  2. In the drop-down list, select General Ledger, and click Go .
  3. Under Available Lists, select Bank Accounts, then click Add.
  4. Enter the appropriate information for the new bank account in each field on all tabs and click OK.
 To add a new checking account
  1. Under Manage Records, click the Chart of Accounts tab.
  2. In the drop-down list, select Add/Edit Chart of Accounts and click Go .
  3. Select the correct heading for the checking account, and click Add Account.
  4. Enter the appropriate information in each field.
  5. On the Account Information tab, select Checking, then select the new bank account.
  6. Click OK.

Return to top

 

I received my bank statement and found that the bank cleared a check for the wrong amount. What do I do?


When you discover that a check for an incorrect amount cleared the bank, contact your bank representative immediately so the error can be corrected. However, it may take a couple of months for the correction to display on your statement, and you need to reconcile your current statement.

To reconcile your current statement, you must post an entry in ACS for the difference in the true amount of the check and the amount that cleared the bank. Determine the difference by subtracting the smaller amount from the larger amount, then enter and post a transaction for the amount of the bank error.

 To correct a bank error while in Bank Reconciliation
  1. In Bank Reconciliation, from the drop-down list, select the bank account, then click the Adjustments tab.
  2. Click Add New Transaction.
  3. In the Transaction Source drop-down list, select Checking Account Credit (CCR) or Checking Account Debit (CDB).
  4. Select the appropriate Checking Account.
  5. Enter a Reference Number, or click Next to assign the next available reference number for the transaction source.
  6. In the Date field, enter or select the date of the bank error.
  7. If you are entering a CCR, click Lookup to select a vendor in the Pay to the Order of field.
  8. Enter the amount of the bank error.
  9. Optional: Enter a memo.
  10. In the Debits field (if entering a CCR), or in the Credits field (if entering a CDB), enter the general ledger account number that you want to charge for the bank error. (You can use the same account number from when you entered the original check or deposit in ACS.)
  11. Click OK, then Yes.
  12. Click the Transactions tab and continue with bank reconciliation.
 To enter a transaction to correct a bank error
  1. Under Manage Records, click the Transactions tab.
  2. Select General Ledger Transactions and click Go .
  3. Click Add/Edit Transactions, then Add.
  4. In the Transaction Source drop-down list, select Checking Account Credit (CCR) or Checking Account Debit (CDB).
  5. Select the appropriate Checking Account.
  6. Enter a Reference Number, or click Next to assign the next available reference number for the transaction source.
  7. In the Date field, enter or select the date of the bank error.
  8. If entering a CCR, click Lookup to select a vendor in the Pay to the Order of field.
  9. Enter the amount of the bank error.
  10. Optional: Enter a memo.
  11. In the Debits field (if entering a CCR), or in the Credits field (if entering a CDB), enter the general ledger account number that you want to charge for the bank error. (You can use the same account number from when you entered the original check or deposit in ACS.)
  12. Click OK, then Yes.
  13. Click Close twice.

Whether you entered the adjustment in Bank Reconciliation or you entered a transaction through Add/Edit Transactions, you must post the transaction.

 To post the bank error transaction
  1. Under Manage Records, click the Transactions tab.
  2. Select General Ledger Transactions and click Go .
  3. Click Post Transactions.
  4. To print the Proof List, click Print. Or, click Preview to preview it before printing.
  5. After reviewing the Proof List, click Post Transactions.
  6. Click Begin Post.
  7. Click Yes, then OK.

Return to top

 

I received a returned check from the bank. How do I enter this in ACS?


If the non-sufficient funds (NSF) check was posted in ACS Contributions or Accounts Receivable and you are interfaced with the ACS General Ledger module, ACS corrects the general ledger when you post the correction in the Contributions or Accounts Receivable module.

If the check was posted in the General Ledger module only, you can deduct the amount of the check from your checking account balance in the general ledger.

If your bank charged your account with a processing fee as a result of the NSF check, you must post the bank charge in the General Ledger module regardless of which module the check was posted in originally.

You can add an NSF check using one of two transaction sources- a checking account credit (CCR) or a deposit (DEP) with a negative amount. The CCR displays with the withdrawals in ACS Bank Reconciliation. The "negative" deposit displays with the deposits in ACS Bank Reconciliation.

 To add a checking account credit (CCR)
  1. Under Manage Records, click the Transactions tab.
  2. Select General Ledger Transactions and click Go .
  3. Click Add/Edit Transactions then click Add.
  4. In the Transaction Source drop-down list, select Checking Account Credit (CCR).
  5. Click Lookup to select a checking account in the list.
  6. Enter a reference number, or click Next to assign the next available reference number for the transaction source.
  7. In the Date field, enter or select the date that the bank posted the NSF to your account.
  8. In the Pay to the Order of field, enter or select a vendor. Since this is a returned check, the individual may not be a vendor for your organization. You can add the individual as a vendor, or you can add a generic vendor with the name “Returned Check.”
  9. Enter the amount of the NSF check plus the amount of the bank charge.
  10. Optional: Enter either the individual’s name (if using the generic vendor name of “Returned Check”) or the phrase “Returned Check” (if you added the individual as a vendor).
  11. Click Split Debit.
  12. In the Debits Account field, enter the general ledger account number that you used for the original deposit. For example, if this check was a part of your weekly deposit for general tithes, enter the account number for general tithes. The checking account displays in the Cred field.
  13. Press Enter until a new distribution line displays.
  14. In the Credits Account field, enter the general ledger checking account number, and press Enter.
  15. In the Amount field, enter the amount of the bank charge for processing the NSF check, and press Enter.
  16. Click in the Debits Account field, and press Enter until a new distribution line displays.
  17. In the Debits Account field, enter the general ledger account number for bank charges or fees, and press Enter.
  18. Optional: Enter a comment.
  19. Click OK, then Yes.
 To add a “negative” deposit (DEP)
  1. Under Manage Records, click the Transactions tab.
  2. Select General Ledger Transactions and click Go .
  3. Click Add/Edit Transactions then click Add.
  4. In the Transaction Source drop-down list, select Deposits (DEP).
  5. Click Split Debit.
  6. In the Debits Account field, click Lookup to select the general ledger checking account number and press Enter.
  7. In the Amount field, enter the amount of the check as a negative, and press Enter. For example, enter -$30.00. Since this is a negative amount, it displays in parentheses after you enter it.
  8. Press Enter until a new distribution line displays.
  9. In the Debits Account field, enter the general ledger checking account number, and press Enter.
  10. In the Amount field, enter the amount of the bank charge for processing the NSF check as a negative, and press Enter. For example, enter -$15.00.
  11. Click in the Credits Account field, select the general ledger account number that you used for the original deposit, and press Enter. For example, if this check was a part of your weekly deposit for general tithes, enter the account number for general tithes.
  12. In the Amount field, enter the amount of the NSF check as a negative amount, and press Enter. The amount displays in parentheses.
  13. Optional: Enter a comment.
  14. Press Enter until a new distribution line displays.
  15. In the Credits Account field, enter the general ledger account number for bank charges or fees, and press Enter.
  16. In the Amount field, enter the amount of the bank charge for processing the NSF check as a negative, and press Enter.
  17. Click OK, then Yes.
  18. Enter a reference number, or click Next to assign the next available reference number for the transaction source DEP.
  19. In the Date field, enter or select the date that the bank posted the NSF to your account.
  20. Click OK, then Yes.

After adding the transaction for the NSF check and the bank charge, you must post the transaction.

Return to top

 

I posted a deposit for the wrong amount. The bank cleared it for the correct amount. How do I correct this in ACS?


If you posted the deposit in ACS Contributions or Accounts Receivable, check the Contributions and Accounts Receivable help for instructions on correcting the contributor’s or customer’s records.

If you are interfaced with the ACS General Ledger module, ACS corrects the general ledger when you post the correction in the Contributions or Accounts Receivable module. However, if you are not interfaced with the general ledger or the deposit was posted in the General Ledger module, you must adjust your checking account balance in ACS for the difference. If you do not make the adjustment and you use ACS Bank Reconciliation, you will not be able to reconcile the bank account.

If you posted the original amount for less than the correct amount, you can post another deposit for the amount of the difference. Use the same date of the original deposit, as well as the correct checking account and the general ledger account for which the funds were given or collected. You can use either the transaction source of Deposit (DEP) or Checking Account Debit (CDB).

If you posted the original amount for more than the correct amount, you can correct the checking account balance the same way you would for a returned check. You can use either the transaction source Checking Account Credit (CCR) or use Deposit (DEP) with a negative amount. The only exception is that you do not have any bank charges or fees to post.

Return to top

 

The book balance in Bank Reconciliation does not match my checking account balance in General Ledger even though I reconcile to 0.00 every month.


The Bank Reconciliation program in ACS assists you in balancing your bank statement only. However, you can reconcile the difference between the ending balance in Bank Reconciliation as compared to the figures on your balance sheet.

In a normal setting where all transactions are posted to the correct month and your bank statement includes the first date of the month and the last date of the month, the Current Bank Statement Balance plus In Transit Deposits plus In Transit Withdrawals should match the balance on your balance sheet for the same month. If the two amounts are not the same, you have transactions included in the amount on your balance sheet that are not included in bank reconciliation or some transactions are included in bank reconciliation that are not included on the balance sheet.

Here are some examples:

  1. Transactions display in Bank Reconciliation based on transaction date (the check date or the deposit date). The balance sheet is calculated by the posting period of transactions. For example, you issue check number 2365 on 03/04/2XXX but date the check 02/14/2XXX. Your posting period is 03/2XXX. Check number 2365 displays in ACS Check Reconciliation for the period 02/01/2XXX-02/28/2XXX and affects the book balance in Check Reconciliation for February. However, the checking account balance in General Ledger is not affected by this check until March because the posting period was 03/2XXX. When you print your balance sheet for February, the amount of check 2365 is not included in the checking account balance because the transaction was posted to 03/2XXX.
  2. A current or previously posted check was voided to a future posting period. For example, a check dated 01/24/2XXX is posted to 01/2XXX but the void is posted to 02/2XXX. You are reconciling your bank statement with dates of 01/01/2XXX-01/31/2XXX. The check and the voided transaction displays in Check Reconciliation for January; however, the balance sheet balance for January includes only the original check, not the void. You should always void a check to the current General Ledger month (yet to be reconciled) so that this does not occur.
  3. The initial beginning balance entered for the checking account in Add/Edit Transactions did not take into consideration in-transit transactions. When entering the beginning balance for a checking account, you should always back out the outstanding checks and deposits from the checking account balance and enter them as transactions so that you will reconcile correctly. This lets you clear the items when they display on your bank statement and match what you see in Check Reconciliation with the balance you see on the balance sheet.

In examples 1 and 2, you must consider the transactions when you attempt to reconcile the items in Check Reconciliation to your balance sheet balance. In example 3, you might not be able to reconcile back to the balance sheet even when considering the transactions mentioned in examples 1 and 2. In this situation, consider making a journal entry if the difference is the same each month (once all transactions are considered).

Return to top

 

I have posted several transactions to the wrong month. Can I correct the posting period?


One of the most important items in General Ledger is the posting period. If you close your month on a timely basis and change the post month to the current month, you should not experience posting errors. However, this is not always possible.

Whenever your posting period is not the same as the current month, you must remember to change the post month/year to the desired period while entering transactions. ACS prompts you to do this, but if you don’t, you must make corrections to ensure financial reports are accurate.

Void the transactions and post them to same month of the original transactions. Then re-enter and post the transactions to the correct posting period.

Return to top

 

I entered a journal entry, and when I clicked OK, I received a warning that I was crossing funds. What does this mean?


The accounts you use to post entries and report to your finance committee or church members make up your Chart of Accounts. These accounts are assigned to funds, which is also known as a set of books in General Ledger. You might have one fund set up for the church’s accounts and another fund set up for the day care’s accounts.

When you add accounts to your chart of accounts, you must attach one of these funds to an account and indicate that the account is for that fund only.

When entering transactions in General Ledger or any other module in ACS Financial Suite, you use debit and credit accounts that are assigned to the same fund. If you use a debit account assigned to the church fund and a credit account assigned to the day care fund, you are “crossing funds,” which means you are not using accounts from the same fund.

You might need to cross funds at times, however. If you are certain that your entry is correct, you can accept the warning and continue posting the transaction. However, if you print your balance sheet by fund, your balance sheet displays out of balance due to the cross-fund transaction.

ACS includes an Automatic Fund Balancing feature that corrects funds after posting so that reports are always in balance by fund.

Return to top

 

I printed my balance sheet, and it indicates that it is out of balance. What do I do?


To determine if you are truly out of balance, print the balance sheet for all accounts with no fund filters and include inactive accounts. If you are in balance when you print the balance sheet using these settings, you are not truly out of balance. The filters you selected caused it to appear out of balance.

If you are only out of balance when printing the balance sheet by fund, you have crossed funds while entering a transaction. For example, you have posted one side of the transaction to one fund and the other side of the transaction to another fund. If the transaction is correct, you can enter a transaction between your fund principal accounts for each fund to offset the amount that you crossed. For example:

Original Entry

Amount

Debit Checking

Church $50.00

Credit Expense

Building $50.00

Correcting Entry to Balance the Amount Between Funds

Amount

Credit Fund Principal

Church $50.00

Debit Fund Principal

Building $50.00


If the transaction was posted incorrectly, you can reverse the transaction and repost it correctly, or you can correct the portion of the transaction that was posted to the wrong fund.

For example, you have two funds: one for the church and one for the day care. You have purchased a new crib for the church nursery that is not used in the day care. When the invoice is paid, the message “This transaction crossed funds and will cause the balance sheet to appear out of balance when printing by fund” displays. When the invoice is paid, the entry is as follows:

Transaction Type

Description

Debit

Nursery Furniture - Day Care

Credit

Checking - Church

This transaction crossed funds and will cause the balance sheet to appear out of balance when printing by fund. You can correct this in one of two ways:

Transaction Type

Description

Debit

Checking - Church

Credit

Nursery Furniture - Day Care

Transaction Type

Description

Debit

Nursery Furniture - Church

Credit

Checking - Church

OR

Transaction Type

Description

Debit

Nursery Furniture - Church

Credit

Nursery Furniture - Day Care

When entering the correcting entries, the system displays a warning that you are crossing funds. Accept the warning since you are correcting a previous entry. Once the correcting transaction is posted, your balance sheet should be in balance for all funds.

Reviewing Crossed Funds

You can print the Funds out of Balance report to review crossed funds.

Return to top

 

How do I enter a check number that won't be used? I want to keep a record of all my check numbers so I can reconcile.


Occasionally, you may not use some checks, so they won't be posted through Accounts Payable or Payroll. This happens if a check gets jammed in the printer, or you print checks and realize that they are incorrect, so you reprint them. These checks have not been posted, so you cannot void them in ACS.

To enter these check numbers in ACS so that they display in Bank Reconciliation, post a Zero Check in General Ledger.

 To post a zero check
  1. Under Manage Records, click the Transactions tab.
  2. Select General Ledger Transactions and click Go .
  3. Click Add/Edit Transactions, then Zero Check.
  4. In the Transaction Source drop-down list, select Check (CHK).
  5. Click Lookup to select the checking account from the list, then click OK.
  6. Enter the Check Number and Date.
  7. In the Pay to the Order of field, enter a vendor. If there is no vendor for this check, you can set up a vendor to use, such as Zero Check or Void Check.
  8. Optional: In the Memo field, enter an explanation.
  9. Click OK, then Yes.
  10. To exit the Add/Edit Transaction window, click Cancel.
  11. Click Yes, then Close.
  12. To print the proof list, click Proof List. 
  13. Click Print, then OK. When you finish printing, click Close.
  14. In the Enter/Post Transactions window, click Post Transactions.
  15. Click Begin Post.
  16. Click Yes, then OK.
  17. Click Close twice.

Return to top