AllBusiness.com
    • Starting a Business
    • Career
    • Sales & Marketing
    • AI
    • Finance & Fundraising
    • M & A
    • Tech
    • Business Resources
    • Business Directory
    1. Home»
    2. Finance»
    3. Clearing Payable and Receivable Balances in a Cash-Basis Balance Sheet»

    Clearing Payable and Receivable Balances in a Cash-Basis Balance Sheet

    Robert Guild
    Finance

    It is not unusual, when you display a cash basis balance sheet, to see balances in accounts payable and accounts receivable. This occurs when there is an unpaid balance and part or all of the item purchased or sold is a balance sheet item, e.g., a fixed asset, inventory item, etc..
    2010-01-24_01

    There is an easy way to identify what your adjusting entry should be to clear A/P and A/R is as follows:
    2010-01-24_02

    • From the QuickBooks menu, select “Reports/Custom Transaction Detail Journal.
    • Select the “Filters” tab.
    • Filter for accounts. Select “multiple accounts” and check accounts receivable and accounts payable.
    • Select the reporting period.
    • Next, select “Paid Status” and select “Open”
    • Select the “Display” tab
    • Select the columns you want to display in your report but always include “Split”, which is the account that is the balance sheet account(s) offset by the receivable or payable.
    • For “Total by”, select “Account List”
    • or “Sort By”, select “Split”
    • Select the “Advanced” icon
    • Select “Report Date” for “Open Balance / Aging”
    You now have a detail of the balance sheet accounts making up the A/R or A/P balance, which you can use to create your journal entries to clear these A/R or A/P balance from the cash basis books.
    2010-01-24_03
    2010-01-24_04

    It is important to remember, that your client is relying on their QuickBooks accounting for financial and management reporting in addition to tax. If you actually record your entries to adjust A/R and A/P in QuickBooks, your client’s accrual based books, including their open invoice and unpaid bills reports, will be incorrect.

    Even is you post them on the last day of the tax reporting year and reverse them on the following day, the client is most likely to use year end financials in reporting to lenders and investors. I suggest you make these “off the books” in preparing a tax return.

    Robert Guild is Advanced Certified QuickBooks ProAdvisor in Austin, TX who conducts CPE courses for CPAs and individual training and group classes to QuickBooks users. His company at www.QBCoach.biz, maintains a sixteen-station QuickBooks lab, providing hands-on training. You can contact him directly at rguild@QBCoach.biz or follow him on twitter at QBPro

    Hot Stories

    Signing papers to incorporate a business

    What Is the Cost of Incorporating a Business?

    A business negotiation in the boardroom

    A Guide to Succeeding in Business Negotiations (With Help From AI)

    Profile: Robert Guild

    Robert Guild is a QuickBooks Certified ProAdvisor, trainer, and accounting consultant offering group and individual training to CPAs, clients, and students.

    BizBuySell
    logo
    AllBusiness.com is a premier business website dedicated to providing entrepreneurs, business owners, and business professionals with articles, insights, actionable advice,
    and cutting-edge guides and resources. Covering a wide range of topics, from starting a business, fundraising, sales and marketing, and leadership, to emerging AI
    technologies and industry trends, AllBusiness.com empowers professionals with the knowledge they need to succeed.
    About UsContact UsExpert AuthorsGuest PostEmail NewsletterAdvertiseCookiesIntellectual PropertyTerms of UsePrivacy Policy
    Copyright © AliBusiness.com All Rights Reserved.
    logo
    • Experts
      • Latest Expert Articles
      • Expert Bios
      • Become an Expert
      • Become a Contributor
    • Starting a Business
      • Home-Based Business
      • Online Business
      • Franchising
      • Buying a Business
      • Selling a Business
      • Starting a Business
    • AI
    • Sales & Marketing
      • Advertising, Marketing & PR
      • Customer Service
      • E-Commerce
      • Pricing and Merchandising
      • Sales
      • Content Marketing
      • Search Engine Marketing
      • Search Engine Optimization
      • Social Media
    • Finance & Fundraising
      • Angel and Venture Funding
      • Accounting and Budgeting
      • Business Planning
      • Financing & Credit
      • Insurance & Risk Management
      • Legal
      • Taxes
      • Personal Finance
    • Technology
      • Apps
      • Cloud Computing
      • Hardware
      • Internet
      • Mobile
      • Security
      • Software
      • SOHO & Home Businesses
      • Office Technology
    • Career
      • Company Culture
      • Compensation & Benefits
      • Employee Evaluations
      • Health & Safety
      • Hiring & Firing
      • Women in Business
      • Outsourcing
      • Your Career
      • Operations
      • Mergers and Acquisitions
    • Operations
    • Mergers & Acquisitions
    • Business Resources
      • AI Dictionary
      • Forms and Agreements
      • Guides
      • Company Profiles
        • Business Directory
        • Create a Profile
        • Sample Profile
      • Business Terms Dictionary
      • Personal Finance Dictionary
      • Slideshows
      • Entrepreneur Profiles
      • Product Reviews
      • Video
    • About Us
      • Create Company Profile
      • Advertise
      • Email Newsletter
      • Contact Us
      • About Us
      • Terms of Use
      • Contribute Content
      • Intellectual Property
      • Privacy
      • Cookies