Criteria: Expenditures used to support grant reimbursement requests should agree with amounts recorded in the general ledger accounting system. Condition and Context: In our testing of expenditures, we noted eleven expenditures selected from the general ledger accounting system by activity that did not agree to the spreadsheets used to support grant reimbursement requests. Cause: Staff use spreadsheets outside of the general ledger accounting system to track expenditures and make grant reimbursement requests. During the June 30, 2022 fiscal year, staff utilized the accounting system to better track grant revenues and expenditures by grant program. However, the breakdown of expenditures used on these spreadsheets did not always match the breakdown used when the expenditures were posted in the general ledger accounting system. Effect or Potential Effect: Expenditures could be duplicated, or eligible expenditures could be omitted from grant reimbursement requests. Recommendation: The coding of expenditures in the general ledger accounting system should reflect the amounts requested under each grant. Additionally, reconciliations should be performed regularly to ensure expenditures are not duplicated or eligible expenditures are not omitted from grant reimbursement requests. Responsible Official's Response: Processes have been put into place to make sure that variances do not occur. Any questions with allowable costs have been referenced in 2 CFR 200 subpart E used for a common procedure for all expenses. The executive director and office manager will review expenditures prior to the distribution of office expenses from among the funds, which will ensure accuracy before the request is made. This will also eliminate the number of correcting entries which need to be adjusted in the expenses.
Criteria: The information in the Schedule of Expenditures of Federal Awards (SEFA) should be derived from, and relate directly to, the underlying accounting and other records used to prepare the financial statements. Condition and Context: The grant expenditures on the SEFA were not reconciled to the general ledger accounting system or other records used to prepare the financial statements. Cause: Revenue accounts were created for each reimbursement grant program beginning October 1, 2020. However, grant receivables were not recorded and revenue accounts for each reimbursement grant program were not reconciled to the underlying expenditures in the accounting and other records used to prepare the financial statements and SEFA. Effect or Potential Effect: The SEFA could be materially misstated if grant expenditures reported on the SEFA are not reconciled to the underlying accounting and other records used to prepare the financial statements. Recommendation: Reimbursement grant revenue accounts should be reconciled to the underlying grant expenditures on the grant request and other reports on a timely basis. Responsible Official's Response: Prior to July 1, 2019, Organization staff did not adequately set up or maintain the accounting software being used. During the year new staff added multiple accounts to ensure that the data in the system matched data showing on government reports. Frequent reconciliations and implementation of policies and procedures will allow data to be accurate in the system and match data that has been submitted to the government from worksheets done in the past.
Criteria: Expenditures used to support grant reimbursement requests should agree with amounts recorded in the general ledger accounting system. Condition and Context: In our testing of expenditures, we noted eleven expenditures selected from the general ledger accounting system by activity that did not agree to the spreadsheets used to support grant reimbursement requests. Cause: Staff use spreadsheets outside of the general ledger accounting system to track expenditures and make grant reimbursement requests. During the June 30, 2022 fiscal year, staff utilized the accounting system to better track grant revenues and expenditures by grant program. However, the breakdown of expenditures used on these spreadsheets did not always match the breakdown used when the expenditures were posted in the general ledger accounting system. Effect or Potential Effect: Expenditures could be duplicated, or eligible expenditures could be omitted from grant reimbursement requests. Recommendation: The coding of expenditures in the general ledger accounting system should reflect the amounts requested under each grant. Additionally, reconciliations should be performed regularly to ensure expenditures are not duplicated or eligible expenditures are not omitted from grant reimbursement requests. Responsible Official's Response: Processes have been put into place to make sure that variances do not occur. Any questions with allowable costs have been referenced in 2 CFR 200 subpart E used for a common procedure for all expenses. The executive director and office manager will review expenditures prior to the distribution of office expenses from among the funds, which will ensure accuracy before the request is made. This will also eliminate the number of correcting entries which need to be adjusted in the expenses.
Criteria: The information in the Schedule of Expenditures of Federal Awards (SEFA) should be derived from, and relate directly to, the underlying accounting and other records used to prepare the financial statements. Condition and Context: The grant expenditures on the SEFA were not reconciled to the general ledger accounting system or other records used to prepare the financial statements. Cause: Revenue accounts were created for each reimbursement grant program beginning October 1, 2020. However, grant receivables were not recorded and revenue accounts for each reimbursement grant program were not reconciled to the underlying expenditures in the accounting and other records used to prepare the financial statements and SEFA. Effect or Potential Effect: The SEFA could be materially misstated if grant expenditures reported on the SEFA are not reconciled to the underlying accounting and other records used to prepare the financial statements. Recommendation: Reimbursement grant revenue accounts should be reconciled to the underlying grant expenditures on the grant request and other reports on a timely basis. Responsible Official's Response: Prior to July 1, 2019, Organization staff did not adequately set up or maintain the accounting software being used. During the year new staff added multiple accounts to ensure that the data in the system matched data showing on government reports. Frequent reconciliations and implementation of policies and procedures will allow data to be accurate in the system and match data that has been submitted to the government from worksheets done in the past.
Criteria: Expenditures used to support grant reimbursement requests should agree with amounts recorded in the general ledger accounting system. Condition and Context: In our testing of expenditures, we noted eleven expenditures selected from the general ledger accounting system by activity that did not agree to the spreadsheets used to support grant reimbursement requests. Cause: Staff use spreadsheets outside of the general ledger accounting system to track expenditures and make grant reimbursement requests. During the June 30, 2022 fiscal year, staff utilized the accounting system to better track grant revenues and expenditures by grant program. However, the breakdown of expenditures used on these spreadsheets did not always match the breakdown used when the expenditures were posted in the general ledger accounting system. Effect or Potential Effect: Expenditures could be duplicated, or eligible expenditures could be omitted from grant reimbursement requests. Recommendation: The coding of expenditures in the general ledger accounting system should reflect the amounts requested under each grant. Additionally, reconciliations should be performed regularly to ensure expenditures are not duplicated or eligible expenditures are not omitted from grant reimbursement requests. Responsible Official's Response: Processes have been put into place to make sure that variances do not occur. Any questions with allowable costs have been referenced in 2 CFR 200 subpart E used for a common procedure for all expenses. The executive director and office manager will review expenditures prior to the distribution of office expenses from among the funds, which will ensure accuracy before the request is made. This will also eliminate the number of correcting entries which need to be adjusted in the expenses.
Criteria: The information in the Schedule of Expenditures of Federal Awards (SEFA) should be derived from, and relate directly to, the underlying accounting and other records used to prepare the financial statements. Condition and Context: The grant expenditures on the SEFA were not reconciled to the general ledger accounting system or other records used to prepare the financial statements. Cause: Revenue accounts were created for each reimbursement grant program beginning October 1, 2020. However, grant receivables were not recorded and revenue accounts for each reimbursement grant program were not reconciled to the underlying expenditures in the accounting and other records used to prepare the financial statements and SEFA. Effect or Potential Effect: The SEFA could be materially misstated if grant expenditures reported on the SEFA are not reconciled to the underlying accounting and other records used to prepare the financial statements. Recommendation: Reimbursement grant revenue accounts should be reconciled to the underlying grant expenditures on the grant request and other reports on a timely basis. Responsible Official's Response: Prior to July 1, 2019, Organization staff did not adequately set up or maintain the accounting software being used. During the year new staff added multiple accounts to ensure that the data in the system matched data showing on government reports. Frequent reconciliations and implementation of policies and procedures will allow data to be accurate in the system and match data that has been submitted to the government from worksheets done in the past.
Criteria: Expenditures used to support grant reimbursement requests should agree with amounts recorded in the general ledger accounting system. Condition and Context: In our testing of expenditures, we noted eleven expenditures selected from the general ledger accounting system by activity that did not agree to the spreadsheets used to support grant reimbursement requests. Cause: Staff use spreadsheets outside of the general ledger accounting system to track expenditures and make grant reimbursement requests. During the June 30, 2022 fiscal year, staff utilized the accounting system to better track grant revenues and expenditures by grant program. However, the breakdown of expenditures used on these spreadsheets did not always match the breakdown used when the expenditures were posted in the general ledger accounting system. Effect or Potential Effect: Expenditures could be duplicated, or eligible expenditures could be omitted from grant reimbursement requests. Recommendation: The coding of expenditures in the general ledger accounting system should reflect the amounts requested under each grant. Additionally, reconciliations should be performed regularly to ensure expenditures are not duplicated or eligible expenditures are not omitted from grant reimbursement requests. Responsible Official's Response: Processes have been put into place to make sure that variances do not occur. Any questions with allowable costs have been referenced in 2 CFR 200 subpart E used for a common procedure for all expenses. The executive director and office manager will review expenditures prior to the distribution of office expenses from among the funds, which will ensure accuracy before the request is made. This will also eliminate the number of correcting entries which need to be adjusted in the expenses.
Criteria: The information in the Schedule of Expenditures of Federal Awards (SEFA) should be derived from, and relate directly to, the underlying accounting and other records used to prepare the financial statements. Condition and Context: The grant expenditures on the SEFA were not reconciled to the general ledger accounting system or other records used to prepare the financial statements. Cause: Revenue accounts were created for each reimbursement grant program beginning October 1, 2020. However, grant receivables were not recorded and revenue accounts for each reimbursement grant program were not reconciled to the underlying expenditures in the accounting and other records used to prepare the financial statements and SEFA. Effect or Potential Effect: The SEFA could be materially misstated if grant expenditures reported on the SEFA are not reconciled to the underlying accounting and other records used to prepare the financial statements. Recommendation: Reimbursement grant revenue accounts should be reconciled to the underlying grant expenditures on the grant request and other reports on a timely basis. Responsible Official's Response: Prior to July 1, 2019, Organization staff did not adequately set up or maintain the accounting software being used. During the year new staff added multiple accounts to ensure that the data in the system matched data showing on government reports. Frequent reconciliations and implementation of policies and procedures will allow data to be accurate in the system and match data that has been submitted to the government from worksheets done in the past.