How-To

Vendor Expense Reports for Insurance Audits from QuickBooks Online – Part 1

This article deals with creating a report that shows your vendor or subcontractor expenses, in summary form, for an insurance audit, from your QuickBooks Online software. Typically for workers compensation and other related liability insurance reasons, the insurance company will ask for financial reports such as: If your books are up to date, then obtaining

Read More

Posting Amazon Revenues with Negative Settlements

This article deals with posting those bi-weekly Amazon revenues statements (payment statements) into your books. However, in this scenario, we will deal specifically with a periodic statement (from Amazon) that nets out to a negative amount. When there is a negative settlement, then Amazon should debit your bank account instead of crediting it for that

Read More

Accounts Receivables Statements in QuickBooks Desktop

This article deals with processing those unique customer statements from the QuickBooks Desktop platform. Customer “statements” are not necessarily the same as the typical Accounts Receivables reports. Accounts Receivables reports will have all the open invoiced amounts, per customer, onto one report. However, customer statements, will focus displaying all that pertinent AR activity onto one

Read More

Open Purchase Orders Sorted by Week with Sent Date Report

This article deals with creating an Open Purchase Orders Detail Report, but will display the following information: Creating this report with exactly these columns of information can be useful if you sell products and are primarily wanting: Knowing how many purchase orders you submit in a given week may help with supply/logistics controls and forecasts.

Read More

Post Amazon Sales Activity into your Books

This article deals with posting those bi-weekly Amazon revenues statements (payment statements) into your books. It is always a good idea to recognize the following bi-weekly Amazon summary activity into your books: The net of all this activity is what will be deposited into your bank account on a periodic basis (bi-weekly in this case).

Read More

Apply Vendor Credit to Old Bills in QuickBooks Online

This article addresses how to manually apply an old vendor payment to open bills in QuickBooks Online. This procedure does NOT utilize the “Pay Bills” function in QuickBooks Online, but rather is just a back-door method of applying a vendor payment to an unpaid bill that directly utilizes the manual posting to the Accounts Payables

Read More

Manually post a Health Insurance split transaction into QuickBooks Online via the Bank Feeds Module

This article addresses how to manually post a health insurance split transaction into QuickBooks Online via the bank feeds module. The Bank Feeds module in QuickBooks online is a very useful tool to be able to download your banking (and credit card) transactions into a temporary holding platform; thus, from this platform you can review

Read More

NetSuite Cash vs. Accrual Reporting

This article addresses how to change the Accounting Basis reporting in your NetSuite bookkeeping software. According to NetSuite, this software, by default, provides financial reporting in an Accrual Basis method “to meet Generally Accepted Accounting Standards”. However, as is common in the business world, you may want to review financial events from a Cash-Basis perspective

Read More

Cash Detail Report in Bill.com

This article addresses how to process a useful Cash Detail report in Bill.com. Sometimes, perhaps for audit or reimbursement reasons, you need to process a cash-based report that details exactly all of the vendor bill payment payouts for a certain time period. Your bookkeeping software may be able to suffice this need here, however some

Read More

Update TX State Unemployment Insurance Payroll Tax Rate in your Payroll Software

This article addresses how to update your Texas Workforce Commission State Unemployment Tax Rate for your business payroll purposes, within your QuickBooks Desktop payroll software (this article is not addressing making updates to your QuickBooks Online payroll software). It is recommended that you, as the small business owner, verify this payroll tax rate at least

Read More