How-To

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

Create Portable Copy of QuickBooks Desktop File

This article addresses how to create a Portable copy of a QuickBooks company file within the QuickBooks Desktop software. This is not to be confused with creating a QuickBooks Backup copy of a QuickBooks company file, which is a completely separate process and copy-type. A Portable copy of a QuickBooks Desktop file is convenient to

Read More