Skip to main content
Products
Product Overview
See how gWorks solutions can help your city or county.
Finance Hub
Simplified fund accounting made for local government.
HR Hub
Payroll and time-tracking made easy for local governments.
FrontDesk
Enable your citizens to interact with your government online.
Utility Billing Hub
Streamline utility billing and revenue collection with a user-friendly utility billing system.
Operations Hub
From permits to work orders, optimize all aspects of your agency's operations.
Maps Hub
Visualize assets on a map to make informed decisions and provide public transparency.
Storage Hub
Securely store all your important documents in one centralized location.
gWorks Payments
Process government payments with ease using an integrated payment processing system.
Support and
Professional Services
Trust friendly, reliable support and professional services to help you every step of the way.
Solutions
Essentials
Core
Enterprise
Company
About
Careers
Resources
All Resources
Insights
Testimonials
Events
Webinars
gWorks University
+1 (888)-608-7666
Support Login
Contact Us
Menu
Products
Cloud Solutions
Product Overview
Finance Hub
HR Hub
FrontDesk
Utility Billing Hub
Operations Hub
Maps Hub
Storage Hub
gWorks Payments
Support and Professional Services
Solutions
Solutions
Essentials
Core
Enterprise
Company
Company
About
Careers
Resources
Resources
Insights
Testimonials
Events
gWorks University
Support Login
© 2020 GIS Workshop, LLC dba gWorks
Contact Us
+1 (888)-608-7666
gWorks Named to GovTech 100 for 5th Consecutive Year
Learn more
Insight

Keeping Your Financials in Balance: Why Checking Your Bank Cash Report Daily is Essential

by
gWorks Editors
No items found.
An image of a small town treasurer working on a financial report at her desk in her office.
No items found.
Share:

Close

As a former City Clerk, I understand the struggle it can be to focus on detailed financial work in an environment where frequent interruption is the norm. Though the reasons for being pulled away from working on city financials are good and necessary facets of a City Clerk/Finance Officer’s position, those disruptions can create an environment where mistakes are easily made. City Hall is a busy place!

An auditor once told me that the most important role of the City Clerk/Finance Officer is to produce timely, accurate financial reports for the City Council. This can be difficult to do when mistakes aren’t caught and corrected right away - especially those that cause a warning on your Bank Cash Report. In this article, I will introduce you to this powerful, yet simple, tool in Finance Hub that can assist you in the objective of keeping your books in balance on a day-to-day basis. Being confident that your books are in balance will give you peace of mind, especially on the busiest of days.

Understanding how the Bank Cash Report works

1. The amounts in the first four columns of the report pull directly from your General Ledger (Previous Month’s Cash Balances, Current Month’s Receipts, Current Month’s Disbursements, Current Month’s Cash Balances).

As you process your daily work in each gWorks Hub, postings that affect the City’s cash accounts (in each fund and each bank) will be reflected on the Bank Cash Report when you complete your Update step.

For example, when you update your daily bank deposit in General Ledger or Receipt Management, those revenue amounts will be included in the Receipts column and will increase the total cash balance in the bank they were updated to.

And when checks are updated in Accounts Payable or Utility Billing, those expense amounts will be included in the Disbursements column and will decrease the total cash balance in the bank they are updated to.

At any given time, the result is a report that provides you with cash balances of the funds that make up each bank account.

2. The transactions that are posted in each module are also updated to the Bank Reconciliation module when you complete your Update step. The Bank Reconciliation module emulates your Bank Statement transactions. Transactions that have not been cleared and reconciled in the Bank Reconciliation module make up the amounts that are seen in the Outstanding Transactions column of the Bank Cash Report. 

3. Your last reconciled bank balance is seen in the last column of the report. The calculated General Ledger balance made up of all cash accounts, plus the total Outstanding Transactions in the Bank Reconciliation module should equal your last reconciled Bank Statement Balance. If it does not, a warning is seen below the bank where this has occurred.

What does it mean when you see a warning on the Bank Cash Report?

A warning on your Bank Cash Report tells you that the General Ledger is not in balance with your Bank. The warning also tells you the amount that they are out of sync. If the amount is positive, it means that your General Ledger module has more posted to it than has been updated to your Bank Reconciliation module. If the amount is negative, then the Bank Rec has more.

The goal is to be sure that every transaction that will show up on your Bank Statement is: 

1. Accounted for on the General Ledger and updated to the Bank Reconciliation module (did you complete your process and update to Bank Rec?).

2. The amounts are accurate and the same in both modules.

3. he posting date (to General Ledger) matches the calendar period (the month it updates to Bank Reconciliation).

When any of these conditions are not met, a warning results to alert you that an error has occurred on the books and caused an imbalance.

Checking your Bank Cash Report daily will tell you in a flash whether best practices have been followed when posting and updating transactions in any modules that affect the cash disposition of the city. Checking the Bank Cash Report regularly assures you that daily work has been done accurately. Catching a mistake quickly makes it easier to identify the issue and correct it. Keeping your books “clean as you go” makes the month-end Bank Reconciliation process a simple task, and in turn, gives you confidence that the reports you provide to your council are an accurate recording of all city finances that they depend on to make sound financial decisions. Learn more about the Bank Cash Report in Finance Hub.

About the Author: Brenda Thompson, gWorks Director of Training, has been an employee at gWorks (formerly Data Technologies) for six years. During her employment at gWorks, Brenda has provided remote and field support, perform new product installations, and has done budget consulting. Prior to her time at gWorks, she worked as a Certified Municipal Clerk/Finance Officer in Iowa for nearly six years.

As a former City Clerk, I understand the struggle it can be to focus on detailed financial work in an environment where frequent interruption is the norm. Though the reasons for being pulled away from working on city financials are good and necessary facets of a City Clerk/Finance Officer’s position, those disruptions can create an environment where mistakes are easily made. City Hall is a busy place!

An auditor once told me that the most important role of the City Clerk/Finance Officer is to produce timely, accurate financial reports for the City Council. This can be difficult to do when mistakes aren’t caught and corrected right away - especially those that cause a warning on your Bank Cash Report. In this article, I will introduce you to this powerful, yet simple, tool in Finance Hub that can assist you in the objective of keeping your books in balance on a day-to-day basis. Being confident that your books are in balance will give you peace of mind, especially on the busiest of days.

Understanding how the Bank Cash Report works

1. The amounts in the first four columns of the report pull directly from your General Ledger (Previous Month’s Cash Balances, Current Month’s Receipts, Current Month’s Disbursements, Current Month’s Cash Balances).

As you process your daily work in each gWorks Hub, postings that affect the City’s cash accounts (in each fund and each bank) will be reflected on the Bank Cash Report when you complete your Update step.

For example, when you update your daily bank deposit in General Ledger or Receipt Management, those revenue amounts will be included in the Receipts column and will increase the total cash balance in the bank they were updated to.

And when checks are updated in Accounts Payable or Utility Billing, those expense amounts will be included in the Disbursements column and will decrease the total cash balance in the bank they are updated to.

At any given time, the result is a report that provides you with cash balances of the funds that make up each bank account.

2. The transactions that are posted in each module are also updated to the Bank Reconciliation module when you complete your Update step. The Bank Reconciliation module emulates your Bank Statement transactions. Transactions that have not been cleared and reconciled in the Bank Reconciliation module make up the amounts that are seen in the Outstanding Transactions column of the Bank Cash Report. 

3. Your last reconciled bank balance is seen in the last column of the report. The calculated General Ledger balance made up of all cash accounts, plus the total Outstanding Transactions in the Bank Reconciliation module should equal your last reconciled Bank Statement Balance. If it does not, a warning is seen below the bank where this has occurred.

What does it mean when you see a warning on the Bank Cash Report?

A warning on your Bank Cash Report tells you that the General Ledger is not in balance with your Bank. The warning also tells you the amount that they are out of sync. If the amount is positive, it means that your General Ledger module has more posted to it than has been updated to your Bank Reconciliation module. If the amount is negative, then the Bank Rec has more.

The goal is to be sure that every transaction that will show up on your Bank Statement is: 

1. Accounted for on the General Ledger and updated to the Bank Reconciliation module (did you complete your process and update to Bank Rec?).

2. The amounts are accurate and the same in both modules.

3. he posting date (to General Ledger) matches the calendar period (the month it updates to Bank Reconciliation).

When any of these conditions are not met, a warning results to alert you that an error has occurred on the books and caused an imbalance.

Checking your Bank Cash Report daily will tell you in a flash whether best practices have been followed when posting and updating transactions in any modules that affect the cash disposition of the city. Checking the Bank Cash Report regularly assures you that daily work has been done accurately. Catching a mistake quickly makes it easier to identify the issue and correct it. Keeping your books “clean as you go” makes the month-end Bank Reconciliation process a simple task, and in turn, gives you confidence that the reports you provide to your council are an accurate recording of all city finances that they depend on to make sound financial decisions. Learn more about the Bank Cash Report in Finance Hub.

About the Author: Brenda Thompson, gWorks Director of Training, has been an employee at gWorks (formerly Data Technologies) for six years. During her employment at gWorks, Brenda has provided remote and field support, perform new product installations, and has done budget consulting. Prior to her time at gWorks, she worked as a Certified Municipal Clerk/Finance Officer in Iowa for nearly six years.

Highlights

Start Date
End DAte
Location and Address

Website

View external link

Add to Calendar
Apple CalendarGoogle CalendarOutlook Calendar

Add to your calendar:

Keeping Your Financials in Balance: Why Checking Your Bank Cash Report Daily is Essential

As a former City Clerk, I understand the struggle it can be to focus on detailed financial work in an environment where frequent interruption is the norm. Though the reasons for being pulled away from working on city financials are good and necessary facets of a City Clerk/Finance Officer’s position, those disruptions can create an environment where mistakes are easily made. City Hall is a busy place!

An auditor once told me that the most important role of the City Clerk/Finance Officer is to produce timely, accurate financial reports for the City Council. This can be difficult to do when mistakes aren’t caught and corrected right away - especially those that cause a warning on your Bank Cash Report. In this article, I will introduce you to this powerful, yet simple, tool in Finance Hub that can assist you in the objective of keeping your books in balance on a day-to-day basis. Being confident that your books are in balance will give you peace of mind, especially on the busiest of days.

Understanding how the Bank Cash Report works

1. The amounts in the first four columns of the report pull directly from your General Ledger (Previous Month’s Cash Balances, Current Month’s Receipts, Current Month’s Disbursements, Current Month’s Cash Balances).

As you process your daily work in each gWorks Hub, postings that affect the City’s cash accounts (in each fund and each bank) will be reflected on the Bank Cash Report when you complete your Update step.

For example, when you update your daily bank deposit in General Ledger or Receipt Management, those revenue amounts will be included in the Receipts column and will increase the total cash balance in the bank they were updated to.

And when checks are updated in Accounts Payable or Utility Billing, those expense amounts will be included in the Disbursements column and will decrease the total cash balance in the bank they are updated to.

At any given time, the result is a report that provides you with cash balances of the funds that make up each bank account.

2. The transactions that are posted in each module are also updated to the Bank Reconciliation module when you complete your Update step. The Bank Reconciliation module emulates your Bank Statement transactions. Transactions that have not been cleared and reconciled in the Bank Reconciliation module make up the amounts that are seen in the Outstanding Transactions column of the Bank Cash Report. 

3. Your last reconciled bank balance is seen in the last column of the report. The calculated General Ledger balance made up of all cash accounts, plus the total Outstanding Transactions in the Bank Reconciliation module should equal your last reconciled Bank Statement Balance. If it does not, a warning is seen below the bank where this has occurred.

What does it mean when you see a warning on the Bank Cash Report?

A warning on your Bank Cash Report tells you that the General Ledger is not in balance with your Bank. The warning also tells you the amount that they are out of sync. If the amount is positive, it means that your General Ledger module has more posted to it than has been updated to your Bank Reconciliation module. If the amount is negative, then the Bank Rec has more.

The goal is to be sure that every transaction that will show up on your Bank Statement is: 

1. Accounted for on the General Ledger and updated to the Bank Reconciliation module (did you complete your process and update to Bank Rec?).

2. The amounts are accurate and the same in both modules.

3. he posting date (to General Ledger) matches the calendar period (the month it updates to Bank Reconciliation).

When any of these conditions are not met, a warning results to alert you that an error has occurred on the books and caused an imbalance.

Checking your Bank Cash Report daily will tell you in a flash whether best practices have been followed when posting and updating transactions in any modules that affect the cash disposition of the city. Checking the Bank Cash Report regularly assures you that daily work has been done accurately. Catching a mistake quickly makes it easier to identify the issue and correct it. Keeping your books “clean as you go” makes the month-end Bank Reconciliation process a simple task, and in turn, gives you confidence that the reports you provide to your council are an accurate recording of all city finances that they depend on to make sound financial decisions. Learn more about the Bank Cash Report in Finance Hub.

About the Author: Brenda Thompson, gWorks Director of Training, has been an employee at gWorks (formerly Data Technologies) for six years. During her employment at gWorks, Brenda has provided remote and field support, perform new product installations, and has done budget consulting. Prior to her time at gWorks, she worked as a Certified Municipal Clerk/Finance Officer in Iowa for nearly six years.

As a former City Clerk, I understand the struggle it can be to focus on detailed financial work in an environment where frequent interruption is the norm. Though the reasons for being pulled away from working on city financials are good and necessary facets of a City Clerk/Finance Officer’s position, those disruptions can create an environment where mistakes are easily made. City Hall is a busy place!

An auditor once told me that the most important role of the City Clerk/Finance Officer is to produce timely, accurate financial reports for the City Council. This can be difficult to do when mistakes aren’t caught and corrected right away - especially those that cause a warning on your Bank Cash Report. In this article, I will introduce you to this powerful, yet simple, tool in Finance Hub that can assist you in the objective of keeping your books in balance on a day-to-day basis. Being confident that your books are in balance will give you peace of mind, especially on the busiest of days.

Understanding how the Bank Cash Report works

1. The amounts in the first four columns of the report pull directly from your General Ledger (Previous Month’s Cash Balances, Current Month’s Receipts, Current Month’s Disbursements, Current Month’s Cash Balances).

As you process your daily work in each gWorks Hub, postings that affect the City’s cash accounts (in each fund and each bank) will be reflected on the Bank Cash Report when you complete your Update step.

For example, when you update your daily bank deposit in General Ledger or Receipt Management, those revenue amounts will be included in the Receipts column and will increase the total cash balance in the bank they were updated to.

And when checks are updated in Accounts Payable or Utility Billing, those expense amounts will be included in the Disbursements column and will decrease the total cash balance in the bank they are updated to.

At any given time, the result is a report that provides you with cash balances of the funds that make up each bank account.

2. The transactions that are posted in each module are also updated to the Bank Reconciliation module when you complete your Update step. The Bank Reconciliation module emulates your Bank Statement transactions. Transactions that have not been cleared and reconciled in the Bank Reconciliation module make up the amounts that are seen in the Outstanding Transactions column of the Bank Cash Report. 

3. Your last reconciled bank balance is seen in the last column of the report. The calculated General Ledger balance made up of all cash accounts, plus the total Outstanding Transactions in the Bank Reconciliation module should equal your last reconciled Bank Statement Balance. If it does not, a warning is seen below the bank where this has occurred.

What does it mean when you see a warning on the Bank Cash Report?

A warning on your Bank Cash Report tells you that the General Ledger is not in balance with your Bank. The warning also tells you the amount that they are out of sync. If the amount is positive, it means that your General Ledger module has more posted to it than has been updated to your Bank Reconciliation module. If the amount is negative, then the Bank Rec has more.

The goal is to be sure that every transaction that will show up on your Bank Statement is: 

1. Accounted for on the General Ledger and updated to the Bank Reconciliation module (did you complete your process and update to Bank Rec?).

2. The amounts are accurate and the same in both modules.

3. he posting date (to General Ledger) matches the calendar period (the month it updates to Bank Reconciliation).

When any of these conditions are not met, a warning results to alert you that an error has occurred on the books and caused an imbalance.

Checking your Bank Cash Report daily will tell you in a flash whether best practices have been followed when posting and updating transactions in any modules that affect the cash disposition of the city. Checking the Bank Cash Report regularly assures you that daily work has been done accurately. Catching a mistake quickly makes it easier to identify the issue and correct it. Keeping your books “clean as you go” makes the month-end Bank Reconciliation process a simple task, and in turn, gives you confidence that the reports you provide to your council are an accurate recording of all city finances that they depend on to make sound financial decisions. Learn more about the Bank Cash Report in Finance Hub.

About the Author: Brenda Thompson, gWorks Director of Training, has been an employee at gWorks (formerly Data Technologies) for six years. During her employment at gWorks, Brenda has provided remote and field support, perform new product installations, and has done budget consulting. Prior to her time at gWorks, she worked as a Certified Municipal Clerk/Finance Officer in Iowa for nearly six years.

Highlights

Start Date
End DAte
Location and Address

Website

View external link

Add to Calendar
Apple CalendarGoogle CalendarOutlook Calendar

Add to your calendar:

Keeping Your Financials in Balance: Why Checking Your Bank Cash Report Daily is Essential

As a former City Clerk, I understand the struggle it can be to focus on detailed financial work in an environment where frequent interruption is the norm. Though the reasons for being pulled away from working on city financials are good and necessary facets of a City Clerk/Finance Officer’s position, those disruptions can create an environment where mistakes are easily made. City Hall is a busy place!

An auditor once told me that the most important role of the City Clerk/Finance Officer is to produce timely, accurate financial reports for the City Council. This can be difficult to do when mistakes aren’t caught and corrected right away - especially those that cause a warning on your Bank Cash Report. In this article, I will introduce you to this powerful, yet simple, tool in Finance Hub that can assist you in the objective of keeping your books in balance on a day-to-day basis. Being confident that your books are in balance will give you peace of mind, especially on the busiest of days.

Understanding how the Bank Cash Report works

1. The amounts in the first four columns of the report pull directly from your General Ledger (Previous Month’s Cash Balances, Current Month’s Receipts, Current Month’s Disbursements, Current Month’s Cash Balances).

As you process your daily work in each gWorks Hub, postings that affect the City’s cash accounts (in each fund and each bank) will be reflected on the Bank Cash Report when you complete your Update step.

For example, when you update your daily bank deposit in General Ledger or Receipt Management, those revenue amounts will be included in the Receipts column and will increase the total cash balance in the bank they were updated to.

And when checks are updated in Accounts Payable or Utility Billing, those expense amounts will be included in the Disbursements column and will decrease the total cash balance in the bank they are updated to.

At any given time, the result is a report that provides you with cash balances of the funds that make up each bank account.

2. The transactions that are posted in each module are also updated to the Bank Reconciliation module when you complete your Update step. The Bank Reconciliation module emulates your Bank Statement transactions. Transactions that have not been cleared and reconciled in the Bank Reconciliation module make up the amounts that are seen in the Outstanding Transactions column of the Bank Cash Report. 

3. Your last reconciled bank balance is seen in the last column of the report. The calculated General Ledger balance made up of all cash accounts, plus the total Outstanding Transactions in the Bank Reconciliation module should equal your last reconciled Bank Statement Balance. If it does not, a warning is seen below the bank where this has occurred.

What does it mean when you see a warning on the Bank Cash Report?

A warning on your Bank Cash Report tells you that the General Ledger is not in balance with your Bank. The warning also tells you the amount that they are out of sync. If the amount is positive, it means that your General Ledger module has more posted to it than has been updated to your Bank Reconciliation module. If the amount is negative, then the Bank Rec has more.

The goal is to be sure that every transaction that will show up on your Bank Statement is: 

1. Accounted for on the General Ledger and updated to the Bank Reconciliation module (did you complete your process and update to Bank Rec?).

2. The amounts are accurate and the same in both modules.

3. he posting date (to General Ledger) matches the calendar period (the month it updates to Bank Reconciliation).

When any of these conditions are not met, a warning results to alert you that an error has occurred on the books and caused an imbalance.

Checking your Bank Cash Report daily will tell you in a flash whether best practices have been followed when posting and updating transactions in any modules that affect the cash disposition of the city. Checking the Bank Cash Report regularly assures you that daily work has been done accurately. Catching a mistake quickly makes it easier to identify the issue and correct it. Keeping your books “clean as you go” makes the month-end Bank Reconciliation process a simple task, and in turn, gives you confidence that the reports you provide to your council are an accurate recording of all city finances that they depend on to make sound financial decisions. Learn more about the Bank Cash Report in Finance Hub.

About the Author: Brenda Thompson, gWorks Director of Training, has been an employee at gWorks (formerly Data Technologies) for six years. During her employment at gWorks, Brenda has provided remote and field support, perform new product installations, and has done budget consulting. Prior to her time at gWorks, she worked as a Certified Municipal Clerk/Finance Officer in Iowa for nearly six years.

As a former City Clerk, I understand the struggle it can be to focus on detailed financial work in an environment where frequent interruption is the norm. Though the reasons for being pulled away from working on city financials are good and necessary facets of a City Clerk/Finance Officer’s position, those disruptions can create an environment where mistakes are easily made. City Hall is a busy place!

An auditor once told me that the most important role of the City Clerk/Finance Officer is to produce timely, accurate financial reports for the City Council. This can be difficult to do when mistakes aren’t caught and corrected right away - especially those that cause a warning on your Bank Cash Report. In this article, I will introduce you to this powerful, yet simple, tool in Finance Hub that can assist you in the objective of keeping your books in balance on a day-to-day basis. Being confident that your books are in balance will give you peace of mind, especially on the busiest of days.

Understanding how the Bank Cash Report works

1. The amounts in the first four columns of the report pull directly from your General Ledger (Previous Month’s Cash Balances, Current Month’s Receipts, Current Month’s Disbursements, Current Month’s Cash Balances).

As you process your daily work in each gWorks Hub, postings that affect the City’s cash accounts (in each fund and each bank) will be reflected on the Bank Cash Report when you complete your Update step.

For example, when you update your daily bank deposit in General Ledger or Receipt Management, those revenue amounts will be included in the Receipts column and will increase the total cash balance in the bank they were updated to.

And when checks are updated in Accounts Payable or Utility Billing, those expense amounts will be included in the Disbursements column and will decrease the total cash balance in the bank they are updated to.

At any given time, the result is a report that provides you with cash balances of the funds that make up each bank account.

2. The transactions that are posted in each module are also updated to the Bank Reconciliation module when you complete your Update step. The Bank Reconciliation module emulates your Bank Statement transactions. Transactions that have not been cleared and reconciled in the Bank Reconciliation module make up the amounts that are seen in the Outstanding Transactions column of the Bank Cash Report. 

3. Your last reconciled bank balance is seen in the last column of the report. The calculated General Ledger balance made up of all cash accounts, plus the total Outstanding Transactions in the Bank Reconciliation module should equal your last reconciled Bank Statement Balance. If it does not, a warning is seen below the bank where this has occurred.

What does it mean when you see a warning on the Bank Cash Report?

A warning on your Bank Cash Report tells you that the General Ledger is not in balance with your Bank. The warning also tells you the amount that they are out of sync. If the amount is positive, it means that your General Ledger module has more posted to it than has been updated to your Bank Reconciliation module. If the amount is negative, then the Bank Rec has more.

The goal is to be sure that every transaction that will show up on your Bank Statement is: 

1. Accounted for on the General Ledger and updated to the Bank Reconciliation module (did you complete your process and update to Bank Rec?).

2. The amounts are accurate and the same in both modules.

3. he posting date (to General Ledger) matches the calendar period (the month it updates to Bank Reconciliation).

When any of these conditions are not met, a warning results to alert you that an error has occurred on the books and caused an imbalance.

Checking your Bank Cash Report daily will tell you in a flash whether best practices have been followed when posting and updating transactions in any modules that affect the cash disposition of the city. Checking the Bank Cash Report regularly assures you that daily work has been done accurately. Catching a mistake quickly makes it easier to identify the issue and correct it. Keeping your books “clean as you go” makes the month-end Bank Reconciliation process a simple task, and in turn, gives you confidence that the reports you provide to your council are an accurate recording of all city finances that they depend on to make sound financial decisions. Learn more about the Bank Cash Report in Finance Hub.

About the Author: Brenda Thompson, gWorks Director of Training, has been an employee at gWorks (formerly Data Technologies) for six years. During her employment at gWorks, Brenda has provided remote and field support, perform new product installations, and has done budget consulting. Prior to her time at gWorks, she worked as a Certified Municipal Clerk/Finance Officer in Iowa for nearly six years.

Highlights

No items found.
Products / Solution
No items found.

As a former City Clerk, I understand the struggle it can be to focus on detailed financial work in an environment where frequent interruption is the norm. Though the reasons for being pulled away from working on city financials are good and necessary facets of a City Clerk/Finance Officer’s position, those disruptions can create an environment where mistakes are easily made. City Hall is a busy place!

An auditor once told me that the most important role of the City Clerk/Finance Officer is to produce timely, accurate financial reports for the City Council. This can be difficult to do when mistakes aren’t caught and corrected right away - especially those that cause a warning on your Bank Cash Report. In this article, I will introduce you to this powerful, yet simple, tool in Finance Hub that can assist you in the objective of keeping your books in balance on a day-to-day basis. Being confident that your books are in balance will give you peace of mind, especially on the busiest of days.

Understanding how the Bank Cash Report works

1. The amounts in the first four columns of the report pull directly from your General Ledger (Previous Month’s Cash Balances, Current Month’s Receipts, Current Month’s Disbursements, Current Month’s Cash Balances).

As you process your daily work in each gWorks Hub, postings that affect the City’s cash accounts (in each fund and each bank) will be reflected on the Bank Cash Report when you complete your Update step.

For example, when you update your daily bank deposit in General Ledger or Receipt Management, those revenue amounts will be included in the Receipts column and will increase the total cash balance in the bank they were updated to.

And when checks are updated in Accounts Payable or Utility Billing, those expense amounts will be included in the Disbursements column and will decrease the total cash balance in the bank they are updated to.

At any given time, the result is a report that provides you with cash balances of the funds that make up each bank account.

2. The transactions that are posted in each module are also updated to the Bank Reconciliation module when you complete your Update step. The Bank Reconciliation module emulates your Bank Statement transactions. Transactions that have not been cleared and reconciled in the Bank Reconciliation module make up the amounts that are seen in the Outstanding Transactions column of the Bank Cash Report. 

3. Your last reconciled bank balance is seen in the last column of the report. The calculated General Ledger balance made up of all cash accounts, plus the total Outstanding Transactions in the Bank Reconciliation module should equal your last reconciled Bank Statement Balance. If it does not, a warning is seen below the bank where this has occurred.

What does it mean when you see a warning on the Bank Cash Report?

A warning on your Bank Cash Report tells you that the General Ledger is not in balance with your Bank. The warning also tells you the amount that they are out of sync. If the amount is positive, it means that your General Ledger module has more posted to it than has been updated to your Bank Reconciliation module. If the amount is negative, then the Bank Rec has more.

The goal is to be sure that every transaction that will show up on your Bank Statement is: 

1. Accounted for on the General Ledger and updated to the Bank Reconciliation module (did you complete your process and update to Bank Rec?).

2. The amounts are accurate and the same in both modules.

3. he posting date (to General Ledger) matches the calendar period (the month it updates to Bank Reconciliation).

When any of these conditions are not met, a warning results to alert you that an error has occurred on the books and caused an imbalance.

Checking your Bank Cash Report daily will tell you in a flash whether best practices have been followed when posting and updating transactions in any modules that affect the cash disposition of the city. Checking the Bank Cash Report regularly assures you that daily work has been done accurately. Catching a mistake quickly makes it easier to identify the issue and correct it. Keeping your books “clean as you go” makes the month-end Bank Reconciliation process a simple task, and in turn, gives you confidence that the reports you provide to your council are an accurate recording of all city finances that they depend on to make sound financial decisions. Learn more about the Bank Cash Report in Finance Hub.

About the Author: Brenda Thompson, gWorks Director of Training, has been an employee at gWorks (formerly Data Technologies) for six years. During her employment at gWorks, Brenda has provided remote and field support, perform new product installations, and has done budget consulting. Prior to her time at gWorks, she worked as a Certified Municipal Clerk/Finance Officer in Iowa for nearly six years.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

As a former City Clerk, I understand the struggle it can be to focus on detailed financial work in an environment where frequent interruption is the norm. Though the reasons for being pulled away from working on city financials are good and necessary facets of a City Clerk/Finance Officer’s position, those disruptions can create an environment where mistakes are easily made. City Hall is a busy place!

An auditor once told me that the most important role of the City Clerk/Finance Officer is to produce timely, accurate financial reports for the City Council. This can be difficult to do when mistakes aren’t caught and corrected right away - especially those that cause a warning on your Bank Cash Report. In this article, I will introduce you to this powerful, yet simple, tool in Finance Hub that can assist you in the objective of keeping your books in balance on a day-to-day basis. Being confident that your books are in balance will give you peace of mind, especially on the busiest of days.

Understanding how the Bank Cash Report works

1. The amounts in the first four columns of the report pull directly from your General Ledger (Previous Month’s Cash Balances, Current Month’s Receipts, Current Month’s Disbursements, Current Month’s Cash Balances).

As you process your daily work in each gWorks Hub, postings that affect the City’s cash accounts (in each fund and each bank) will be reflected on the Bank Cash Report when you complete your Update step.

For example, when you update your daily bank deposit in General Ledger or Receipt Management, those revenue amounts will be included in the Receipts column and will increase the total cash balance in the bank they were updated to.

And when checks are updated in Accounts Payable or Utility Billing, those expense amounts will be included in the Disbursements column and will decrease the total cash balance in the bank they are updated to.

At any given time, the result is a report that provides you with cash balances of the funds that make up each bank account.

2. The transactions that are posted in each module are also updated to the Bank Reconciliation module when you complete your Update step. The Bank Reconciliation module emulates your Bank Statement transactions. Transactions that have not been cleared and reconciled in the Bank Reconciliation module make up the amounts that are seen in the Outstanding Transactions column of the Bank Cash Report. 

3. Your last reconciled bank balance is seen in the last column of the report. The calculated General Ledger balance made up of all cash accounts, plus the total Outstanding Transactions in the Bank Reconciliation module should equal your last reconciled Bank Statement Balance. If it does not, a warning is seen below the bank where this has occurred.

What does it mean when you see a warning on the Bank Cash Report?

A warning on your Bank Cash Report tells you that the General Ledger is not in balance with your Bank. The warning also tells you the amount that they are out of sync. If the amount is positive, it means that your General Ledger module has more posted to it than has been updated to your Bank Reconciliation module. If the amount is negative, then the Bank Rec has more.

The goal is to be sure that every transaction that will show up on your Bank Statement is: 

1. Accounted for on the General Ledger and updated to the Bank Reconciliation module (did you complete your process and update to Bank Rec?).

2. The amounts are accurate and the same in both modules.

3. he posting date (to General Ledger) matches the calendar period (the month it updates to Bank Reconciliation).

When any of these conditions are not met, a warning results to alert you that an error has occurred on the books and caused an imbalance.

Checking your Bank Cash Report daily will tell you in a flash whether best practices have been followed when posting and updating transactions in any modules that affect the cash disposition of the city. Checking the Bank Cash Report regularly assures you that daily work has been done accurately. Catching a mistake quickly makes it easier to identify the issue and correct it. Keeping your books “clean as you go” makes the month-end Bank Reconciliation process a simple task, and in turn, gives you confidence that the reports you provide to your council are an accurate recording of all city finances that they depend on to make sound financial decisions. Learn more about the Bank Cash Report in Finance Hub.

About the Author: Brenda Thompson, gWorks Director of Training, has been an employee at gWorks (formerly Data Technologies) for six years. During her employment at gWorks, Brenda has provided remote and field support, perform new product installations, and has done budget consulting. Prior to her time at gWorks, she worked as a Certified Municipal Clerk/Finance Officer in Iowa for nearly six years.

Free Download

Download this guide to see how PAM can help reduce risks in your community.

Download Now
Resource

6 Reports That Can Help Cities Responsibly Manage Their Finances

Read More
Insight

Transforming the Local Government Experience

With a knack for reverse-engineering and a drive to innovate, Ergin Yilmaz is shaping the future of data infrastructure at gWorks for small-town governments. Read his story in our Behind the Software series!
Read More
Solution

Simplified Fund Accounting for Government

Consolidate data, track revenue, expenses, maintain budgets, and generate accurate reports for better financial decisions.
See Solution
Solution

Front Desk: A modern, convenient relationship between citizen and government

Having accurate and current asset inventory data enables local government to effectively allocate resources which saves time, costs, and disruptions.
See Solution

Ready to get started? Talk with our team today

Reliable & easy-to-use solutions to help your government know what’s going on, act decisively, and benefit greatly.

Contact our team
Secure
Simple
Integrated
Empowering Local Government through Simple Software Solutions
PRODUCTS
OverviewFrontDeskPaymentsUtility Billing HubHR HubOps HubFinance HubMaps HubStorage HubPubWorksCounty WebGIS
Solutions
EssentialsCoreEnterprise
Resources
All ResourcesInsightsTestimonialsEventsWebinarsgWorks University
Company
AboutCareersContact UsRequest a ConsultationSupport Login
888-608-7666
info@gworks.com
3905 South 148th St
Ste 200
Omaha, NE 68144
Privacy PolicyTerms of UseCookie Manager
© 2020 GIS Workshop, LLC dba gWorks. All Rights Reserved

Your Privacy is important to us

Customize your cookie preferences or click “Accept All” to agree to the storing of cookies on your device. View our Privacy Policy for more information.
Preferences
Accept All
Deny
Privacy Preference Center

Below we list the different types of cookies that we use on the Site.  The specific cookies that we use, and the categories to which they belong, are available in the consent manager. To the extent any personal information is collected through cookies, our Privacy Policy applies and complements this Policy.

Always Allow Cookies
Close
Manage Consent Preferences
Required cookies enable you to navigate the Site and to use its services and features.  Without these absolutely necessary cookies, we may not be able to provide the Site or certain services or features, and the Site will not perform as smoothly for you as we would like it to.

These cookies are used to deliver advertising that is more relevant to you and your interests. They may also be used to limit the number of times you see an advertisement and measure the effectiveness of advertising campaigns. Advertising networks usually place them with the website operator’s permission.

Personalization cookies can provide a more customized experience by remembering choices a user makes, such as their language, location, or username.

These cookies allow us to analyze your use of the Site to evaluate and improve our performance, for example, by providing us information about how our site is used.

Reject AllConfirm My Choices
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.