http://webmail.libionline.net City of Beaumont Audit
 
 I have totaled all payroll transactions from the City of Beaumont General Ledger for the months of May through October, 2012. I have compared these totals with the Bank Statements and Council Check Warrants and found the general ledger has $1,301,068.96 more expenses attached to employee payroll than the automatic deposits documented on the Bank Statement.

The City Council Check Warrants have no correlation to either the Bank Statements or General Ledger. The Dates listed on the Check Warrant are not the correct Payroll Dates. The only time the Check Warrant dates and General Ledger dates corresponded was 10/25/12 when the City was shifting so much money it entered the payroll transaction # 222921 with the date of 10/25/12 instead of the correct payroll date of 10/18/12.

The Check Warrants do verify the 'Guardian Insurance' check dates & amounts correlate with the Bank Statement, but the actual amounts recorded on the General Ledger average $2,000 more than the actual amounts paid.

I have seen the practice of listing alternate dates on the check warrants in other California cities. I have no idea how this 'procedure' originated, but each time the Finance Director lists the incorrect dates or amounts they are committing State and Federal felonies.

I audited a total of thirteen (13) pay periods from 05/01/12 – 10/25/12. I also included the General Leger payroll for 11/01/12 because 10/25/12 was not actually a pay period.

Total Payroll per the Bank Statement from May – October was $ 5,750,85.97.

Total Payroll per General Ledger from May – October was $ 7,051.923.93.

This leaves a material misstatement of $1,301.068.96.

There is a difference of $473,080.04 between what the City states on the general ledger and the Bank Statement Payroll Deductions. Every pay date is overstated by at least $10,000.00. Deductions for vision, dental, disability, and life insurance are separate transactions and the check is issued to Guardian to pay for these costs. But the City also takes these deductions from the Payroll Transactions.

For example: 7000 - Transit Department shows the standard monthly dental deduction of 32.61 was paid on 05/01/12, but the City of Beaumont attached another $150.00 dental deduction to the 05/05/12 payroll.

The largest discrepancy was on 07/27/12 when the bank statement shows payroll was $468,612.36, but the general ledger shows a total of $711,731.73 in payroll expenses. The City padded the employees' payroll by $1/4 Million on that one pay date alone.

The Month of October was a 'lost weekend' for the Accounting Department. Payroll issued on 10/05/12 was 'normal'; Bank Statement reported $421,431.06 in payroll, City general ledger recordings totaled $437,932.54. This leaves a $ 16,501.48 discrepancy, but for the City of Beaumont, that's normal.

The Bank shows payroll was issued 10/18/12 for $453,411.42 and shows no other payroll transaction between 10/05/12 and the end of the month.

The General Ledger lists their payroll on 10/25/12 with transaction # 222921 for $459,647.00.

The Beaumont General Ledger does have payroll transactions dated 10/12/12, but these are additional checks issued:

10/12/12 - #219889 - $105,323.91
10/12/12 - # 219909 - $29,702.97

Apparently the City 'got confused' when they issued additional checks for $135,026.88.

There are a total of seventeen (17) additional transactions totaling $827,998.92. The checks range in amounts, but every month there is an transaction over $100,000:

# 210440 – 06/08/12 - $107,838.85
#212635 – 06/30/12 - $106,940.65
#215697 – 08/17/12 - $107,434.68
#218901 – 09/28/12 - $103,123.34
#219889 – 10/12/12 - $105,323.91

The above transactions are coded 3020- Medical Insurance with the memo 'Cigna Health Care'. But there are no Cigna transactions listed on the Check Warrants. The City carries Kaiser and the Guardian Insurance to cover dental, disability, vision, & life.

The City also shows a massive transfers of money listed on the Council Check Warrants as 'Mutual of Omaha', but the City of Beaumont doesn't carry Mutual of Omaha Insurance. On the Bank Statements the automatic debit transactions are listed as 'MG Trust'.

There was a total of $78,864.54 in payroll charged to a department coded 7100. This department is not listed on the budget.

On 05/17/12 the City posted transaction # 209836 giving a FICA credit of $439.14 to department 2000 – Quality of Life. This department does not have any FICA deductions taken from their employee's paychecks. Any overpayment to FICA should be credited back to the individual department.

The department of the City Manager is the only department to have 'STD Insurance'. The level of nasty the City Manager must exhibit to require STD Insurance has yet to be determined.

If I can find $1.3 Million addition employee costs expenses added to payroll in five months, the City of Beaumont is most likely padding their Payroll Account by $3 Million/year.
 


Comments

05/18/2015 3:51am

Education is the basic need for every human. How possible is it for you to rely on a dissertation writer that you don’t know? It is just a matter of faith knowing that you must have some good work done.

Reply
12/14/2015 10:43pm

Biology Assignment Help Assignment and Online Homework Help Biology Assignment Help Biologists use experimentation and observation in order to develop an understanding about the natural world.

Reply
12/14/2015 11:01pm

Our website is number 1 in Auditing Assignment Help and Auditing Homework Help. This is preferred destination for various students to get their Audit Projects and Homework Done.

Reply

We are No. 1 in Electronics Engineering Assignment Help; Hire us for your Electronics Engineering Project and Homework Help.

Reply

Get your finance homework help for assignments and projects from top finance writers. We are number 1 academic writing service when it comes to financial management assignments.

Reply
12/15/2015 1:18am

We are number 1 in MathCad help. This is leading website for getting the Mathcad Homework & Assignment help taken from. We also provide Tutors for Mathcad as well as do complete projects of mathcad.

Reply
12/15/2015 1:43am

Our website is number in Statistics/ Stats homework help. This is preferred destination for various students to get their Statistics assignment help taken from.

Reply
12/15/2015 2:47am

Our website is number 1 in ASP Assignment Help and ASP.net Homework Help. This is preferred destination for various students to get their ASP Projects and Homework Done. ASPHelpOnline.com is easily the number 1 destination to get ASP help.

Reply
12/15/2015 3:30am

We are Number 1 in Accounting Assignment Help - Accounting Homework Help. Hire us for Accounting Term Papers and Accounting Projects.

Reply
02/05/2016 2:37am

Here are some facts about payroll tax. It refer to income taxes withheld from employees’ income, including Social Security and Medicare taxes. All employers are legally required to withhold payroll taxes from the paychecks of their employees and remit the withheld funds to the IRS.

Reply
03/13/2016 5:07am

So lot to occur over your amazing blog. Your blog procures me a fantastic transaction of enjoyable.. Salubrious lot beside the scene.

Reply

Fantastic work! My friend recommended this blog and he was totally right keep up the great work.

Reply

ncome, including Social Security and Medicare taxes. All employers are legally required to withhold payroll taxes from the paychecks of their emp

Reply

ecurity and Medicare taxes. All employers are legally required to withhold ecurity and Medicare taxes. All employers are legally required to withhold ecurity and Medicare taxes. All employers are legally required to withhold

Reply

urity and Medicare taxes. All employers are legally requrity and Medicare taxes. All employers are legally requrity and Medicare taxes. All employers are legally requrity and Medicare taxes. All employers are legally req

Reply

ocial Security and Medicare taxes. All employers are legally required to withhold payroll taxes from the paychecks of their employees and remocial Security and Medicare taxes. All employers are legally required to withhold payroll taxes from the paychecks of their employees and rem

Reply
10/07/2016 12:51pm

hold payroll taxes from the paychecks of their employees and remocial Security and Medicare taxes. Allhold payroll taxes from the paychecks of their employees and remocial Security and Medicare taxes. All

Reply
10/07/2016 12:51pm

rom the paychecks of their employees and remocial Security and Medicrom the paychecks of their employees and remocial Security and Medicrom the paychecks of their employees and remocial Security and Medic

Reply

oyees and remocial Security and Medicrom the paychecks of theiroyees and remocial Security and Medicrom the paychecks of theiroyees and remocial Security and Medicrom the paychecks of their

Reply

Whether you are a retail store owner, a home owner or a business man, security is always an important matter of concern of all to protect people, property and resources from thieves, burglars and other unwanted elements. Nevertheless, there are numerous benefits and features of CCTV camera that makes it useful and invaluable device. It has fostered a sense of security in homes and work places. Here are some of the noteworthy benefits of CCTV installation:

Reply
10/13/2016 2:17am

Relish your taste buds at the comfort of your home with variety of cuisine options that can get easily delivered at your doorstep. There may be days when you do not have time to cook for yourself and your family, or you may be just bored of daily routine food, at such situations the virtual world comes to your rescue. Even if you do not have time to step out, and drive to the nearest restaurant, you can easily browse through svarious options available and easily order food online in Mumbai. City life is hectic and one may not find time to lighten up, but with the trend of virtual world fulfilling all your essential needs, obtaining your favorite meals are no longer a difficult task.

Reply
10/13/2016 2:18am

Carpets are important part of offices. Associated with luxury; carpets add grace and aesthetic appeal to an office. It could be a doctor's clinic, lawyers' office, boutiques, restaurants or any kind of office. Carpets make workplaces look even more beautiful and add a touch of artistic quality. Moreover good quality carpets can also help reduce noises

Reply
10/13/2016 2:18am

Carpets are important part of offices. Associated with luxury; carpets add grace and aesthetic appeal to an office. It could be a doctor's clinic, lawyers' office, boutiques, restaurants or any kind of office. Carpets make workplaces look even more beautiful and add a touch of artistic quality. Moreover good quality carpets can also help reduce noises
Carpets are important part of offices. Associated with luxury; carpets add grace and aesthetic appeal to an office. It could be a doctor's clinic, lawyers' office, boutiques, restaurants or any kind of office. Carpets make workplaces look even more beautiful and add a touch of artistic quality. Moreover good quality carpets can also help reduce noises

Reply

We have totally payroll transactions from the City of Beaumont General Ledger for the months.

Reply



Leave a Reply


Contact: libi@libionline.netCity of Beaumont Audit