How To Close The Books For Dummies. Financial Close In 15 Steps

The Financial Controller
19 Jul 202220:15

Summary

TLDRThe video script outlines a comprehensive guide for corporate controllers to ensure the accuracy and completeness of financial statements before issuance. It details a 16-step process starting from bank reconciliation to locking the period in accounting software, emphasizing the importance of regular reconciliations, expense recognition, and comparison of actuals to budget and prior periods to identify any discrepancies or anomalies. The guide serves as a valuable resource for accounting professionals looking to enhance their month-end closing procedures.

Takeaways

  • πŸ“‹ The process of closing the books involves ensuring completeness and accuracy of financial records before issuing financial statements.
  • πŸ’Ό As an accounting professional, you should regularly reconcile bank statements to capture unrecorded expenses and cash receipts.
  • 🧾 Accounts Receivable should be reconciled by comparing invoices, purchase orders, and shipping notices to ensure all transactions are accounted for.
  • πŸ’Ή Prepaid expenses must be tracked and amortized correctly to reflect accurate expenses in the current period.
  • πŸ“ˆ Inventory should be reconciled with warehouse reports and reviewed for obsolescence or expiration to adjust costs accurately.
  • 🏒 Property, Plant, and Equipment (PP&E) requires regular review for capitalization, depreciation, and obsolete machinery.
  • πŸ’³ Accounts Payable must be ensured to be complete and reconciled with the trial balance and aged accounts payable to maintain cash flow accuracy.
  • πŸ’³ Credit card expenses should be reconciled for completeness and proper allocation of expenses to the correct accounts.
  • πŸ“Š Accrued expenses need to be recorded and tracked in an Excel file, with adjustments made as invoices are received.
  • πŸ’° Deferred revenue must be managed by recognizing a liability for payments received but not yet earned, and amortizing it over the delivery period.
  • πŸ”’ Long-term debt should be tracked outside the accounting software and reconciled with lender statements, with interest accrued as necessary.

Q & A

  • What does it mean to 'close the books' in the context of accounting?

    -Closing the books refers to the process of ensuring that all business transactions are accurately captured on the financial statements and that the books and records are complete and accurate on the accounting software, ready for the generation of financial statements.

  • Why is it important to perform a bank reconciliation?

    -Bank reconciliation is crucial for capturing any unrecorded expenses or cash applications from customers, ensuring that all financial transactions are accurately reflected in the financial statements. Without it, there is a risk of having expenses incurred by the business that are not captured on the income statement, leading to inaccuracies.

  • How often should one perform a bank reconciliation?

    -It is recommended to perform a bank reconciliation on a weekly basis rather than waiting until the end of the month. This helps to manage the volume of transactions and ensures that expenses and cash receipts are recorded promptly and accurately.

  • What is the purpose of reconciling accounts receivable?

    -Reconciling accounts receivable ensures completeness by comparing invoices issued to purchase orders and shipping notices. This process helps to confirm that all purchase orders have been shipped and fulfilled and that all shipments have been correctly invoiced, thereby ensuring accurate financial reporting.

  • How can one ensure completeness in a software or consumption-based service business?

    -In such businesses, one can perform a month-over-month customer analytics by comparing customer data or invoicing data from the current period, the previous period, and possibly the period before that. This helps to identify any fluctuations or anomalies and ensures that all transactions are accurately recorded.

  • What are the three key steps in managing property, plant, and equipment (PP&E) on the balance sheet?

    -The three key steps are: reviewing large purchases to ensure they are capitalized correctly, running depreciation to record the wear and tear of assets over time, and reviewing for obsolete machinery that may need to be written off.

  • Why is it important to reconcile accounts payable?

    -Reconciling accounts payable ensures that all vendor invoices have been received and recorded correctly. It helps to identify any discrepancies between the trial balance and the subledger, which if left unaddressed, can become more complex over time and potentially lead to inaccurate financial reporting.

  • What is the role of accrued expenses in the financial statements?

    -Accrued expenses represent expenses that have been incurred but not yet paid or invoiced. They are recognized as a liability to ensure that the financial statements accurately reflect the company's obligations and the true cost of operations for the period.

  • How does one handle deferred revenue in accounting?

    -Deferred revenue is managed by maintaining a table that shows the receipt of funds from customers for goods or services not yet delivered. This table is reviewed monthly to determine the portion of the deferred revenue that should be amortized and recognized as revenue in the current period.

  • What is the purpose of performing an actual versus budget analysis?

    -This analysis helps to identify any variances between what was budgeted and what actually occurred. It captures any items that may have been recorded in the budget but not in the actual financial statements, prompting further investigation and necessary adjustments to ensure the accuracy of the financial records.

  • Why is a period-over-period comparison useful in the financial closing process?

    -A period-over-period comparison helps to identify any anomalies or fluctuations in the financial data. By analyzing changes in key financial metrics over time, it can highlight areas that require further investigation, such as unexpected increases or decreases in expenses or revenues.

Outlines

00:00

πŸ“š Introduction to Closing the Books

This paragraph introduces the concept of closing the books in accounting, emphasizing the importance of ensuring all business transactions are accurately captured in financial statements. The speaker, an accounting manager, outlines the process of closing the books, which involves a series of steps to confirm the completeness and accuracy of financial records. The purpose is to enable confident issuance of financial statements, which are crucial for analyzing business performance.

05:00

🧾 Steps for Closing the Books

The speaker outlines a detailed process for closing the books, which includes 14-15 steps. The initial steps involve using previous financial statements as a reference and conducting a bank reconciliation to ensure all cash transactions are recorded. The process continues with reconciling accounts receivable, examining the aging of accounts, and reconciling prepaid expenses. The speaker emphasizes the importance of performing these steps on a weekly basis to avoid end-of-month backlogs and ensure accurate financial reporting.

10:01

πŸ” Reconciling Balances and Inventory

This paragraph delves into reconciling the balance of accounts receivable with the general ledger and examining the aging of accounts. The speaker then discusses reconciling prepaid expenses, inventory, and property, plant, and equipment (PP&E). It highlights the need to review large purchases, run depreciation, and check for obsolete machinery. The importance of reviewing inventory against warehouse reports and assessing for obsolescence or expired goods is also stressed to maintain accurate financial records.

15:03

πŸ’Ό Liabilities and Accruals Management

The speaker discusses managing liabilities and accruals, starting with accounts payable, ensuring completeness of recorded invoices, reconciliation of subledgers, and checking the aging report. The paragraph then covers credit card reconciliations, the importance of expense allocation, and the management of accrued expenses, including maintaining an Excel file for tracking. Additionally, the speaker explains the handling of deferred revenue, which involves recognizing a liability for goods or services not yet delivered, and the need for monthly review and amortization of these amounts.

πŸ“ˆ Financial Analysis and Period Locking

The final steps in closing the books involve analyzing revenue and expenses, ensuring they are recorded in accordance with accrual accounting principles. The speaker describes the process of reviewing open purchase orders to identify any unrecorded expenses and conducting a budget versus actual analysis to capture any discrepancies. A period-over-period comparison is recommended to identify anomalies in accounting. The paragraph concludes with the step of locking the period in accounting software to prevent further changes, signifying the completion of the financial closing process.

Mindmap

Keywords

πŸ’‘Bank Reconciliation

Bank reconciliation is the process of comparing the ending balance on a company's books with the corresponding balance on the bank statement to ensure that all transactions are accurately recorded. In the context of the video, it is a crucial step in closing the books as it helps capture any unrecorded expenses or cash applications, ensuring the completeness and accuracy of financial records. An example from the script is the recommendation to perform bank reconciliation on a weekly basis to avoid a large volume of transactions at month-end.

πŸ’‘Accounts Receivable

Accounts receivable (AR) refers to the money owed to a company by its customers for goods or services provided on credit. In the video, the speaker emphasizes the importance of reconciling AR to ensure completeness, which involves invoicing customers accurately and timely. The process includes comparing invoices issued, purchase orders received, and shipping notices to confirm that all sales have been recorded and all shipments have been billed. The script also mentions examining AR aging to follow up on customers who are not paying on time.

πŸ’‘Prepaid Expenses

Prepaid expenses are costs paid in advance for goods or services that will be received in the future. In the video, the controller suggests maintaining an external Excel file to track prepaid expenses and ensuring that these expenses are properly amortized over the period they relate to. This process is part of the closing procedures to ensure that the balance sheet accurately reflects the company's financial position by not overstating these prepayments.

πŸ’‘Inventory

Inventory refers to the goods and materials held by a business for sale in the ordinary course of business. In the context of the video, the speaker advises performing a monthly reconciliation of inventory with the warehouse report to ensure that the quantities recorded in the accounting system match the physical stock. This is important for financial accuracy and to prevent discrepancies that could be identified by auditors, as well as to identify any obsolete or expired goods that need to be written off.

πŸ’‘Property, Plant, and Equipment (PP&E)

PP&E encompasses long-term tangible assets that a company uses in its operations, such as buildings, machinery, and equipment. In the video, the controller highlights the need to review large purchases to ensure they are capitalized correctly, run depreciation to allocate the cost of these assets over their useful life, and review for obsolete machinery that may need to be written off. These steps are essential for accurately reflecting the company's assets and expenses on the financial statements.

πŸ’‘Accounts Payable

Accounts payable (AP) represents the amounts a company owes to its suppliers for goods and services received on credit. In the video, the controller emphasizes the importance of ensuring that all vendor invoices have been received and recorded, reconciling the trial balance with the subledger, and checking the aging report to ensure timely payments. These steps help maintain the company's financial health and relationships with vendors by avoiding unnecessary inflation of cash balances and late payments.

πŸ’‘Accrued Expenses

Accrued expenses are liabilities that represent expenses incurred but not yet paid or billed. In the video, the controller advises maintaining an Excel file to track accruals and reviewing it monthly to ensure that no amounts are aged that should be reversed. This process is critical for matching expenses to the periods in which they are incurred, in accordance with accrual accounting principles, and for maintaining the accuracy of financial statements.

πŸ’‘Deferred Revenue

Deferred revenue is a liability that arises when a company receives payment for goods or services that have not yet been delivered. In the video, the controller explains the need to maintain a table showing receipts from customers and to review this table monthly to determine the amounts that should be amortized as revenue. This ensures that revenue is recognized in the correct accounting period, in accordance with the principles of revenue recognition.

πŸ’‘Long-term Debt

Long-term debt refers to loans or other borrowings that have a term longer than one year. In the video, the controller discusses the importance of maintaining a record of these loans, reconciling them with the lender's statements, and recognizing the interest expense as it accrues. This ensures that the company's financial position is accurately reflected and that debt obligations are properly accounted for on the balance sheet.

πŸ’‘Revenue Recognition

Revenue recognition is the process of recording revenue in the period in which it is earned, as opposed to when it is billed or cash is received. In the video, the controller explains that this is based on the fulfillment of performance obligations as per accounting standards, such as ASC 606. The process involves analyzing revenue by customer to identify any adjustments needed for accrual accounting, ensuring that revenue is recognized when it is earned and not just when invoiced or paid.

πŸ’‘Expense Accrual

Expense accrual is the accounting practice of recording an expense in the period it is incurred, regardless of when the payment is made or received. In the video, the controller describes the need to identify expense accounts that require accrual adjustments at the month's end, such as payroll expenses that have been incurred but not yet paid. This process is essential for the accurate reflection of a company's financial performance and compliance with accrual accounting principles.

πŸ’‘Budget Analysis

Budget analysis involves comparing actual financial results with the budgeted amounts to identify variances and understand the reasons behind them. In the video, the controller suggests performing an actual versus budget analysis to capture any items that were recorded in the budget but not in the actual financial statements, which can prompt questions and lead to the identification of accounting anomalies. This analysis helps in financial planning and control by ensuring that budgeted expenses are aligned with actual expenses incurred.

Highlights

Closing the books involves ensuring all business transactions are accurately captured on financial statements.

Bank reconciliation is crucial to capture unrecorded expenses or cash receipts.

Reconciling accounts receivable ensures completeness of invoices issued and received.

Prepaid expenses should be tracked and amortized as the expense is incurred.

Inventory reconciliation with warehouse reports is necessary to identify any discrepancies.

Reviewing property, plant, and equipment for large purchases, depreciation, and obsolescence is vital.

Ensuring all vendor invoices are received and recorded for accounts payable is important for accuracy.

Credit card statements must be reconciled for completeness of expenses.

Accrued expenses represent incurred costs not yet paid and require monthly review and reversal if invoiced.

Deferred revenue must be tracked and amortized over the period to which it relates.

Long-term debt requires tracking of loans, payments, and interest accruals.

Revenue recognition should follow the guidelines of accounting standards to ensure accuracy.

Expenses should be reviewed for accrual adjustments to match the period in which they are incurred.

Open purchase order reports help identify expenses that need to be recorded but have not yet been invoiced.

Budget versus actual analysis can reveal discrepancies and prompt necessary accruals.

Period over period comparison helps identify anomalies in accounting and financial performance.

Locking the period in accounting software prevents further changes once the books are closed.

Transcripts

play00:00

hey guys welcome back to another video

play00:01

before i close the books and issue

play00:03

financial statements there is a series

play00:05

of steps that i take as a corporate

play00:07

controller to make sure that the all of

play00:09

the business transactions are captured

play00:11

on the financial statements and in this

play00:13

video i wanted to create a comprehensive

play00:15

guide of all of the steps all the things

play00:17

you have to visit before you go ahead

play00:19

and issue financial statements with

play00:21

confidence

play00:25

[Music]

play00:29

hey guys welcome back to another

play00:30

accounting lecture bill hannah here in

play00:32

today's video we'll be focusing on

play00:33

period and closing or closing the books

play00:35

and what it means to close the books and

play00:37

generate financial statements and if you

play00:39

go back in time when accounting was done

play00:41

in actual physical paper and columnar

play00:44

pages closing the books literally meant

play00:46

that you entered all of your expenses

play00:48

and all your revenue and you're ready to

play00:50

literally take the book and actually

play00:52

close it right but what we say today

play00:55

when we say close the books what we mean

play00:57

is that your books and records are

play00:59

complete on the accounting software and

play01:01

that you're ready to generate financial

play01:03

statements so it's all about

play01:04

completeness and accuracy of the books

play01:06

and records that is closing the books

play01:09

and so as you go up in the letter of an

play01:11

accounting manager assistant controller

play01:13

and a controller and you get to my

play01:15

position today as a cobra controller

play01:17

you'll find that your cfo will come to

play01:19

you maybe day five or six of the months

play01:21

and say are we closed for the previous

play01:23

months are we done are we closed with

play01:25

the books and the reason why is because

play01:27

everybody's eager to download the

play01:28

financial statements and begin to

play01:30

analyze the performance of the business

play01:32

so this is briefly what it means to

play01:34

close the books and what we'll do in

play01:35

this lecture is i want to break it down

play01:37

to maybe 14 or 15 steps that you can

play01:40

take to close the books and records all

play01:42

right so to simplify the process for you

play01:44

because at the end of the day it's

play01:45

really easy right we're not really

play01:47

launching rockets into space right this

play01:49

is pretty easy stuff so what we'll do is

play01:51

you grab a copy of the financial

play01:53

statements from the previous period

play01:54

right so grab a copy of the balance

play01:56

sheet and a copy of the income statement

play01:58

and we'll go through the main accounts

play01:59

and talk about the things that you need

play02:01

to do to close the books all right so

play02:03

we'll grab a copy of the balance sheet

play02:04

from the previous period and look at it

play02:06

and the first section on the current

play02:07

assets you'll find cash and cash

play02:10

equivalents and what you need to do here

play02:12

is a bank reconciliation and what a bank

play02:14

reconciliation is is grabbing the ending

play02:16

balance from the bank statement and

play02:18

reconciling it to what you have on your

play02:19

books and records right so what that

play02:22

allows you to do is capture any

play02:23

unrecorded expenses or any cash

play02:26

application that's coming in cash

play02:27

receipts from customer to close out

play02:29

accounts receivable right if you don't

play02:31

do a bank reconciliation what you're

play02:33

going to end up with is that you're

play02:34

going to have expenses that have been

play02:36

incurred whether by the business and not

play02:38

being captured on the income statement

play02:39

right so this is the risk here if you

play02:41

don't reconcile the banking statement so

play02:43

that's the first thing you have to do

play02:44

and my pro tip on this one is that you

play02:47

do it on a weekly basis don't wait till

play02:49

month end to reconcile the bank because

play02:51

then your a you'll end up with a large

play02:54

volume of transactions that you need to

play02:55

record in terms of expenses or cash

play02:57

receipts from customers my

play02:58

recommendation is to do it on a weekly

play03:00

basis a preliminary reconciliation in

play03:03

your accounting software while you enter

play03:05

in the balance and then begin to apply

play03:07

expenses and and cash receipts from

play03:09

customers as you receive it on a weekly

play03:12

basis so that's what you do for cash

play03:14

step two is to reconcile accounts

play03:15

receivable and when you look at accounts

play03:17

receivable the reason why you want to

play03:18

reconcile it it's very similar to the

play03:20

concept of reconciling the bank

play03:21

statement it's all about completeness

play03:23

with the bank statement you're making

play03:24

sure that all the transactions are

play03:26

complete on your books and records with

play03:28

accounts receivable you're also

play03:29

concerned with completeness and with

play03:31

completeness here means that you invoice

play03:33

the customers you need to invoice right

play03:35

so your billing process could be if you

play03:37

are a product product based business you

play03:39

are issuing an invoice every time you

play03:41

ship a product right so that's if you

play03:43

have a product based business if you

play03:45

have a software business for example

play03:47

maybe you're issuing only one monthly

play03:49

invoices or annual invoice for the

play03:50

period covering the whole period right

play03:52

whatever the case is so if you have a

play03:55

business that ships a product what you

play03:57

need to do for completeness is to

play03:58

compare a list of invoices in a period

play04:00

that you issued to a list of purchase

play04:02

orders from the customers to a list of

play04:04

shipping notices from the warehouse

play04:06

let's say like a three-way check list of

play04:08

invoices that you issued purchase orders

play04:11

two shipping notices to make sure that

play04:13

all of the purchase orders that you

play04:14

received have been shipped and fulfilled

play04:17

and then all of the ship shipment and

play04:19

fulfillment have been invoiced

play04:21

accordingly right so this is a three or

play04:23

three-way match you can do to ensure

play04:25

completeness uh if you have a software

play04:28

business for example or a consumption

play04:30

based service business you can do a

play04:32

month over months customer analytics so

play04:35

you grab

play04:36

your customer data or your invoicing

play04:38

data for this current period the

play04:40

previous period and maybe the previous

play04:41

the period previous to that and do a

play04:44

three period comparison uh and then

play04:46

you'll see any kind of fluctuation any

play04:49

hills or valleys to capture any

play04:51

anomalies and that will help you capture

play04:53

anything that's incomplete so that's in

play04:55

terms of completeness and then what you

play04:57

can do after that is reconcile the aging

play05:00

sub ledger so you take the subledger

play05:02

which is your ledger by customer and

play05:04

reconcile it to the general ledger uh

play05:06

which is the balance on your trial

play05:07

balance to make sure equal each other

play05:10

because if they don't equal each other

play05:11

and there is a reconciling item you're

play05:13

better off catching it now than waiting

play05:16

down the line and having to go back to

play05:18

previous videos to reconcile so

play05:20

reconciling your balance in a trial

play05:22

balance to your sub ledger is really

play05:24

important here

play05:26

and then the final thing to do for ar is

play05:28

examining ar aging so downloading ar

play05:30

aging by bucket um you know current 30

play05:33

days plus 60 days plus and looking at

play05:35

your customers who are not paying you

play05:37

and following up to make sure that

play05:38

you're receiving the cash on time and by

play05:41

the way all of these items here are

play05:42

addressed in detail in the controller

play05:44

academy link in the description below

play05:47

step three is to reconcile prepaid

play05:49

expenses and as you can see we are going

play05:51

down the balance sheet accounts right

play05:52

now so we are at prepaid expenses and

play05:54

for prepaid expenses you should keep an

play05:56

excel file an outside excel file showing

play05:59

the items from the vendor that you've

play06:01

received that are prepaid and this is

play06:04

what that means is that this is an

play06:05

expense of the future that you pre-paid

play06:07

today so it lives on the balance sheet

play06:09

rather than the income statement right

play06:11

and as you then incur the actual expense

play06:13

in the future then you begin to amortize

play06:15

the prepaid expenses so what you should

play06:17

do

play06:18

for this year is to look at the excel

play06:19

file for reasonableness right you go

play06:21

through it item by item and see uh

play06:23

you're amortizing correctly you're

play06:25

booking an amortizing journal entry on

play06:27

your books and records to recognize any

play06:29

expense that already got incurred in

play06:31

this current period and make sure it

play06:33

reconciles and it's reasonable at month

play06:35

end all right one important pro tip here

play06:37

is to develop a month enclosed checklist

play06:39

or a closed calendar so i'm going to

play06:41

leave a link down below to a video i

play06:43

made on how to develop the checklist and

play06:45

also a link to an excel file of a sample

play06:47

checklist you can download and begin to

play06:49

use it yourself today okay number four

play06:51

is inventory and whether you're

play06:53

maintaining your list of inventory by

play06:55

sku in the accounting erp software or in

play06:58

excel you should be doing a month in

play06:59

reconciliation to the warehouse report

play07:01

so you should

play07:03

contact the warehouse each month and get

play07:06

a listing by skew of the quantities of

play07:08

the inventory and reconcile that to what

play07:10

you have on your books and records

play07:12

because if you don't do that and you

play07:14

have some sort of discrepancy you're not

play07:16

catching then the auditor when they come

play07:18

in they'll catch that discrepancy and

play07:19

you have to write it off so you're

play07:20

better off doing it yourself and

play07:22

reconciling to the warehouse to catch

play07:24

any differences and then you should also

play07:26

review for obsolescence and expired

play07:29

goods so you should always get if you're

play07:31

selling for example perishable goods or

play07:33

some items that have an expiration date

play07:36

you should always look at it by skew buy

play07:37

a bucket of expiration a month end to

play07:40

determine if there are any write-offs

play07:42

that you have to do you have to write

play07:43

down inventory maybe the cost of goods

play07:45

sold if you have expired goods or

play07:47

obsolete goods so two things reconcile

play07:49

to warehouse reconcile aging for expired

play07:52

items number five is pp and e or

play07:54

property plant and equipment and this is

play07:56

your factory buildings your machinery

play07:58

your laptops and all this good stuff and

play08:00

what you should be doing here are three

play08:01

things number one review for large

play08:03

purchases that needs to be capitalized

play08:05

in a period so maybe you do that by

play08:07

reviewing accounts payable or speaking

play08:09

to somebody from accounts payable team

play08:10

and making sure that every purchase that

play08:12

is large enough to be capitalized under

play08:14

the company's fixed asset policy is

play08:16

being capitalized correctly on the books

play08:18

number one number two is to run

play08:20

depreciation and if you're running sap

play08:22

or netsuite large enough erp software

play08:25

that's literally a push of a button that

play08:26

will run depreciation for you

play08:29

if not if you're using like quickbooks

play08:30

online you might have to run

play08:32

depreciation in excel and then take the

play08:34

je or journal entry from excel and book

play08:36

it into your accounting software number

play08:39

three is to review for obsolete um

play08:41

property or machinery so for example if

play08:44

you have any

play08:45

machinery that's not being utilized

play08:47

anymore that's obsolete uh you might

play08:49

need to write that off uh to the p l the

play08:52

three things review large purchases run

play08:54

depreciation and review for obsolete

play08:56

machinery

play09:01

all right up next and under current

play09:02

liabilities we'll encounter accounts

play09:04

payable so you need to do three things

play09:06

here the first one is to ensure that all

play09:09

vendor invoices have been received and

play09:10

recorded and a lot of times what you

play09:13

have is an inbox like maybe ap at

play09:15

xyz.com your ap email that receives all

play09:18

the vendor invoices so just making sure

play09:21

that you review that inbox and double

play09:23

check that all of the the vendor

play09:25

invoices in there have been recorded on

play09:27

the books and records this number one

play09:28

number two is a reconciliation between

play09:31

the trial balance and your subledger so

play09:33

take the amount of balance of ap from

play09:36

the tri balance reconcile it to your

play09:38

subledger or your aging and ap by vendor

play09:41

to make sure the balance ties because if

play09:43

it doesn't it means you have a

play09:44

difference that you should resolve now

play09:47

rather than to wait a few periods and

play09:48

then it becomes more complex as the

play09:51

snowball gets bigger and bigger right so

play09:53

you should tackle it early number three

play09:55

is to check the aging ap aging and make

play09:58

sure that there is nothing that's being

play10:00

aged

play10:01

that for example if you owe a vendor a

play10:03

certain amount of money uh within a

play10:05

certain period of time you should pay to

play10:07

them because if you don't uh you're

play10:09

inflating the cash balance unnecessarily

play10:11

on your books and you're building maybe

play10:13

um breaking down the relationship with

play10:15

vendors so you should be paying on time

play10:17

within the credit

play10:18

uh term or the payment term that you

play10:20

have with the vendor so three things uh

play10:22

ensure completeness of when the invoice

play10:23

is recorded two reconciliation sub

play10:25

ledger three check the aging report all

play10:28

right number seven as we go down the

play10:30

list on the balance sheet here under

play10:31

current liabilities is credit cards so

play10:34

for credit cards just like bank

play10:35

statements we're concerned with

play10:37

completeness so what you should be doing

play10:39

is reconciling the balance when you book

play10:40

some records to the balance on the

play10:42

credit card statement a month end and

play10:44

oftentimes what you do is you have a

play10:47

feed a bank feed or and whether it's a

play10:49

csv upload or an actual api feed from

play10:52

the bank into your accounting software

play10:54

that just feeds in the information and

play10:56

it gets recorded on your books and

play10:58

records and you're just what you do is

play11:00

you're making sure that the expense

play11:02

accounts allocated to each line item is

play11:04

correct you go in and you review the

play11:05

nature of the expense and you assign to

play11:07

the right expense line item right so

play11:10

completeness and reconciliation a month

play11:12

end of credit cards credit cards are

play11:14

often issued to executives uh certain

play11:16

buyers around the company have credit

play11:18

cards so make sure you have a good

play11:20

listing of the credit cards that are

play11:21

being used and reconcile those on a

play11:23

monthly basis number eight as we go down

play11:25

the list is accrued expenses and what

play11:27

accrued expenses is is a liability to

play11:29

represent the expenses that you incurred

play11:31

but you haven't yet paid the vendors

play11:33

right so maybe you're in current expense

play11:35

today but you haven't been invoiced yet

play11:37

so it's not an accounts payable yet

play11:39

but you're recognizing a liability here

play11:41

by debiting the expense and crediting

play11:44

the liability account so what you should

play11:45

be doing for this is that you should be

play11:46

maintaining an excel file with all of

play11:49

your vendors that you have accrual for

play11:51

and you review it on a monthly basis uh

play11:54

a for reasonableness to check that

play11:55

nothing is aged on it that should be

play11:57

reversed and uh b is for reversals so to

play12:00

check on it line by line and see if you

play12:03

receive the vendor invoice and you

play12:04

booked it to ap you should be reversing

play12:07

out of this account because it shouldn't

play12:08

live in two places it should only live

play12:11

either in accurate expenses or accounts

play12:12

payable if you receive the vendor

play12:14

invoice you have to reverse the accrual

play12:16

here uh so two things to maintain an

play12:19

excel file and secondly is to reverse

play12:22

any accrual that's been already invoiced

play12:24

by the vendor and number nine as we go

play12:26

down the list is deferred revenue or

play12:28

sometimes referred to as unearned

play12:30

revenue and the reason why it's a

play12:32

liability is because you receive maybe

play12:34

some funds from a customer and you

play12:36

haven't yet delivered the good or the

play12:38

service see what you're recognizing here

play12:39

is a liability or an obligation

play12:42

that you uh will have to deliver this

play12:44

good or service in the future so what

play12:46

you should be doing is maintain an excel

play12:48

table for this to show by customer and

play12:50

by payment to show what you received and

play12:53

then secondly is to review on a monthly

play12:56

basis this table here for reasonableness

play12:58

line by line to see what you need to

play13:00

amortize and so an example is let's say

play13:02

you receive a hundred thousand dollars

play13:05

for an entire year of platform fees from

play13:07

a customer and you need to amortize that

play13:10

on 12 months so what you should be doing

play13:11

is going into excel file and amortizing

play13:14

the 100k over a whole year and then

play13:16

record as revenue recognize the revenue

play13:19

to the p l every month for the one

play13:22

twelfth of the hundred thousand dollars

play13:23

as an example so deferred revenue is

play13:26

under and revenue you should be

play13:27

maintaining a table outside of the arp

play13:29

software uh and then reviewing and

play13:31

amortizing uh the line items on a

play13:33

monthly basis all right number 10 is

play13:35

long-term debt and this is for loans or

play13:37

business loans that have a term longer

play13:39

than a year or 12 months that's why it's

play13:41

long term right

play13:42

with that you need to be maintaining a

play13:44

table outside of europe software to show

play13:46

that the number of loans that you have

play13:47

outstanding and then reconcile those to

play13:50

the statement from the lender uh just to

play13:52

make sure they're capturing any uh

play13:54

payments that you're paying down maybe

play13:56

your loans and you need to record a

play13:57

journal entry to recognize the reduction

play14:00

in cash and reduction in long-term

play14:02

liability right so review the table that

play14:05

you have and then for the interest on

play14:07

these loans you might be having to for

play14:09

example if you owe an interest on the

play14:11

loan but you haven't paid it yet then

play14:13

you need to be recording an accrual for

play14:15

that interest

play14:16

okay that's long-term debt all right so

play14:18

with that we're done with the balance

play14:19

sheet and now we can move to the income

play14:21

statement and the income statement

play14:22

really we're going to just break it down

play14:23

to step number 11 which is revenue and

play14:25

step 12 which is expenses so for revenue

play14:29

what i do is is i download a report of

play14:31

revenue for the month by customer and i

play14:33

go through it and analyze to see if

play14:35

there are any things that need to be

play14:36

adjusted for accrual accounting right

play14:38

and accrual accounting says that you

play14:40

record revenue as you earn it not when

play14:42

you invoice it or not when you receive

play14:44

the cash but when you earn the revenue

play14:46

and earning the revenue is very specific

play14:48

and it's based on asc or accounting

play14:50

standard qualification 606 uh that has

play14:53

rules around when to recognize revenue

play14:55

and it's mainly around the idea of

play14:57

earning a revenue and fulfilling the

play14:59

performance obligation so the best way

play15:01

is to download a list of revenue by

play15:03

customer and go through it and identify

play15:05

some of these problematic customers that

play15:07

has specific clauses in their contracts

play15:09

that require some accrual adjustment to

play15:12

revenue so that's 11 or revenue and then

play15:15

for step 12 it's going to be analyzing

play15:17

the expenses so look at your expense

play15:19

accounts for operating expenses and what

play15:22

i do for expenses is to look at the

play15:24

expense accounts by gl accounts like the

play15:26

detailed gl accounts which shows payroll

play15:28

expense vacation expense software

play15:31

expense marketing all of these things

play15:32

right and begin to identify the expense

play15:35

accounts that require an accrual

play15:36

adjustment a month end and accrual uh

play15:39

says that an expense is recorded when

play15:40

the expense is incurred right not when

play15:43

the expense is paid or not when the

play15:45

invoice is received from a vendor but

play15:47

when the actual expense itself or the

play15:49

service from the vendor or from the

play15:51

employee has been rendered right so an

play15:53

example is if you look at payroll

play15:54

expenses and let's say you're paying

play15:56

your payroll on a two-week cadence right

play15:59

so you have two weeks in the period two

play16:00

weeks plus two weeks and then you have

play16:02

maybe two or three days toward the end

play16:04

of the period that you need to accrue

play16:05

for as a debit to payroll expense and a

play16:08

credit to accrued payroll right so

play16:11

identifying these expenses that require

play16:14

an accrual of monthly end that's step

play16:16

number 12.

play16:17

step 13 is going to be to review an open

play16:20

purchase order report and what i mean by

play16:22

that is that you download a listing of

play16:25

all of the purchase orders with any

play16:26

company uh that haven't been invoiced by

play16:29

the vendor you haven't received an

play16:30

invoice from the vendor yet against it

play16:32

right what that allows you to do is to

play16:35

figure out if there is any expense that

play16:37

have been incurred during the period

play16:38

that needs to be recorded on the books

play16:40

and records if the service have been say

play16:42

significantly completed by the vendor

play16:44

but you haven't yet received an invoice

play16:46

from the vendor right so i highly

play16:48

recommend implementing a system of

play16:50

purchase order with the purchase orders

play16:51

within your company uh whether you're

play16:54

buying inventory or maybe only if you're

play16:56

buying uh

play16:57

software services marketing services or

play16:59

anything like that uh because that

play17:01

allows you for two things number one is

play17:03

to control spend so you're always

play17:06

approving your spend before it happens

play17:08

not after it happens right

play17:11

and then secondly it allows you for this

play17:13

to have a correct accounting because

play17:15

then if you have a po process then you

play17:17

can download an open po report of

play17:19

montand and double check it against your

play17:22

accounts payable to make sure that you

play17:24

have accruals that are correct at month

play17:27

end so step number 13 is to review and

play17:29

open purchase order report all right so

play17:32

now we're at step 14 now we're pretty

play17:33

much almost done we now have all or

play17:36

almost all of the transaction are

play17:37

complete on the books of records step

play17:39

number 14 is going to be to perform an

play17:42

actual versus budget analysis so now

play17:44

that you're almost comfortable that

play17:46

everything is already recorded on the

play17:47

books and records you download a set of

play17:49

financial statements and you do an

play17:51

actual to budget comparison what that

play17:53

allows you to do is to capture any items

play17:55

maybe recorded in the budget but not in

play17:57

the actual financial statements that

play17:59

might prompt a question and then you say

play18:01

huh here i have a marketing expense in

play18:03

the budget for 20k but i don't see that

play18:05

in the financial statements there's

play18:07

something changed in the plan so you

play18:08

reach out to the marketing person you

play18:10

say that something change in the budget

play18:12

and you might say yeah well the 20k it's

play18:14

not going to be spent now it's going to

play18:15

be spent down the line then you're fine

play18:17

then it's okay i don't have to accrue

play18:19

anything but what that might uh discover

play18:22

is that if the 20k has been budgeted for

play18:24

but you don't see it in the actual

play18:26

results you reach out to the marketing

play18:27

person use he'll say well yeah we have

play18:30

the service has been incurred and it

play18:31

needs to be recorded but uh there is no

play18:33

po for it and there's no vendor invoice

play18:36

but the service has been uh rendered by

play18:38

the vendor right so that that will uh

play18:40

enable you to do an accrual for that

play18:42

service in this case so doing a budget

play18:44

to actual analysis will allow you to

play18:46

figure out any of these variances that

play18:48

will help you catch accounting anomalies

play18:51

step 15 and we're almost done here is to

play18:53

do a period over period comparison so

play18:55

download the financial statements if

play18:57

you're doing a monthly close then you

play18:59

download four months including the

play19:01

current monthly closing and you do a

play19:03

comparison a fluctuation analysis to

play19:06

capture any anomalies so for example for

play19:08

payroll if you do an analysis that shows

play19:11

the payroll have gone up by say five

play19:13

percent right so what you should be

play19:15

asking is did my head count increase uh

play19:18

by five percent to prompt increase in

play19:20

payroll by five percent

play19:22

and then if you look at heck count and

play19:24

it went up by five percent then you're

play19:26

like okay that makes sense then but if

play19:28

your head count went up by say 20

play19:31

and you're looking at payroll and went

play19:33

up only by five percent well then

play19:34

something is wrong here right so you see

play19:37

a period over period analysis is really

play19:39

helpful in capturing anomalies in the

play19:41

accounting step 16 or the final step is

play19:43

to lock the period in the accounting

play19:45

software so that no more changes are

play19:47

being done either by accident or on

play19:49

purpose by the accounting staff no more

play19:51

changes so you need to lock the period

play19:53

once you're satisfied

play20:14

you

Rate This
β˜…
β˜…
β˜…
β˜…
β˜…

5.0 / 5 (0 votes)

Related Tags
Book ClosingFinancial StatementsAccounting ProcessController's GuideBank ReconciliationAccounts ReceivableExpense ManagementRevenue RecognitionBudget AnalysisAccounting Software