QuickBooks Month End Close

Quickbooks Month End Close Procedure and Checklist for Small Business Accounting

Month End Close Tips and Tricks

 

What is a Quickbooks month end close? Basic steps include

  • Record deposits
  • Entering vendor payments
  • Bank Reconciliation
  • Review financial balances
  • printing and saving month end reports
  • Lock the current accounting period.

 

Each month Small Businesses should complete these steps to confirm all transactions are entered and reflected in the financial reports. This process when performed in a timely manner will support decisions made for the business based on financial reports.

Tips and tricks

The bank reconciliation is one of the most important steps. Remember to complete this each month in your QuickBooks company file.

QuickBooks accounts to reviewed and reconciled each month

  • Cash
  • Accounts Receivable
  • Inventory
  • Accounts Payable
  • Gross Wages

If you are a larger company there may be additional accounts that need to be reviewed for accuracy each month such as fixed assets, prepaid expenses, loan accounts and tax liabilities. If you are distribution or manufacturing company it may include WIP, Finished goods and cost of goods sold. For a month end close checklist follow the links below to request a month end close checklist in excel for your small business.

Request QuickBooks Month-End Close Checklist

View QuickBooks Quarter End Close Checklist

View QuickBooks Year End Close Checklist

Here’s how to close the books:

  1. Choose the Gear icon and select Company Settings.
  2. Choose Advanced.
  3. In the Accounting section, click on the Edit icon.
  4. Check the box labeled Close the books.
  5. Enter a closing date. …
  6. Decide what you want users to see if they try to save a transaction that is dated prior to the closing date:

For more information and support on Small Business Accounting Software visit Accounting Business Solutions by JCS and for services on Sage Software Timeslips visit www.timeslipssupport.com

QuickBooks Consolidated Financials

QuickBooks Consolidated Financial Statements

What is QuickBooks Consolidated financials?

A set of QuickBooks Consolidated Financial Statements consists of reports that show the operations, cash flows, and financial position of a parent company and each individual subsidiary. You can easily print each companies’ financial statements from your QuickBooks Company files. To get consolidated financials from multiple QuickBooks company data files you need to have a set of consolidated reports capable of easily combining them.

These financial statements include assets, liabilities, equity, income, expenses and cash flows. The balance in individual accounts from each subsidiary are totaled and presented in a single total and as a single economic entity

The top 3 reasons to have QuickBooks Consolidated Financials at your fingertips?

Consolidate – add up financial information from multiple companies with accurate totals

Standardize – to present professional financials with consistent formatting

Automate – set them up and use them over and over again with the click of a button

What financial statements can be consolidated?

standard balance sheet

income statement

cash flow statements

Other statements

Who looks at consolidated financials?

Bookkeepers

Individual Owners

Holding Company Controller

Board of directors

Financial Institutions

Tips and tricks for consolidated financials

Each company should be on the same fiscal year

The chart of accounts needs to be standardized across all companies

All entries should be recorded in the individual companies prior to generating consolidated statements

Presentation of individual and consolidated statements should be in the same format

Advanced Reporting for QuickBooks

How do I print QuickBooks Financial Statements?

  • Start QuickBooks
  • From the Reports menu
  • choose Company & Financial
  • then choose the desired QuickBooks Financial Statement
  • On the Display tab
  • change the date range to 12 months
  • (for example, select Last Fiscal Year in the Dates drop-down)
  • Change the Columns drop-down from ‘Total only’ to ‘Month.’

How do I print QuickBooks Financial Statements to PDF?

  1. Select the report or form you want to print in QuickBooks
  2. Click the “File” menu
  3. Select “Print” to use a third-party PDF printer
  4. Then, select your PDF printer from the options

Alternatively, select “File” and “Save as PDF” to use the built-in QuickBooks PDF printer.

How do I print QuickBooks Financial Statements to excel?

  1. Click on the Reports menu.
  2. Choose Company & Financial.
  3. Select either Profit and Loss by Class or Balance Sheet by Class.
  4. Choose the Dates.
  5. Click on the Excel button.

How do I print the QuickBooks Balance Sheet?

  • Start QuickBooks
  • From the Reports menu
  • choose Reports
  • Company & Financial
  • Balance Sheet Standard
  • On the Display tab
  • change the date range to 12 months
  • (for example, select Last Fiscal Year in the Dates drop-down)
  • Modify the Columns drop-down from ‘Total only’ to ‘Month.’

How do I customize the QuickBooks Balance Sheet?

You can customize your Balance Sheet report to show Year-over-Year columns.

  1. Go to Reports.
  2. In the search bar, search for and open Balance Sheet Comparison.
  3. Select Customize.
  4. Under Rows/Columns, select the Columns drop-down, then change it to the desired comparison period.
  5. Select Memorize
  6. Enter a new name to save if you wish to create a custom version

How do I print the QuickBooks Income Statement?

  • Start QuickBooks
  • From the Reports menu
  • choose Company & Financial
  • then choose Profit & Loss Standard
  • On the Display tab
  • change the date range to 12 months
  • (for example, select Last Fiscal Year in the Dates drop-down).
  • Change the Columns drop-down from ‘Total only’ to ‘Month.’
  • Learn QuickBooks

How do I customize the QuickBooks Income Statement?

You can customize your Income Statement report to show Year-over-Year columns.

Step 1: Run a report

  1. Go to the Reports menu.
  2. Find and open the report you want. …
  3. Use the basic filters at the top of the report to adjust things like the report dates.
  4. Select Customize to open the customization window.
  5. Under Rows/Columns, select the Columns drop-down, then change it to the desired comparison period.
  6. Select Memorize
  7. Enter a new name to save if you wish to create a custom version
QuickBooks Consolidated Financials

QuickBooks Consolidated Financials

#nearme, #quickbooksnearme, #quickbooksconsolidatedfinancials, #quickbookconsolidatedincomestatement, #consolidatequickbookscompanies, #quickbooksinventory, #quickbooksBOM, #quickbooksassembly, #tipsforconsolidationofaccounts, #quickbooksapp, #quickbooksenterprisesubsidaries

Sage Timeslips Support

 

X