How-To Archives - Page 2 of 9

Single Customer Invoices Report in QuickBooks Online

This article addresses the issue of creating a customer invoices history report in QuickBooks online that does not duplicate sales invoice number data if each of your invoices have multiple lines of sales items. For example: If you create one invoice, but with multiple lines of different items that you sold within that one invoice,

Vendor Expense Reports for Insurance Audits – Part 2

This article continues the series ofcreating a report that shows your vendor or subcontractor expenses, for an insurance audit, from your QuickBooks Online software. However, unlike the first blog in this series, this article will included expenses that have been capitalized into a Work-In-Progress asset account, such as for Spec home builders. To recap the

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

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

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

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.

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).

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

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

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