How-To

Work the Bank Feeds Module in QuickBooks Online – Part 2

This article continues the discussion (from Part 1) of some basic tasks of working within the bank feeds module in QuickBooks Online. As a reminder, the bank feeds module, also known as the “Banking Transactions” module, in QuickBooks Online is a very convenient bookkeeping tool to post transactions in your bookkeeping software. You can also

Read More

Work the Bank Feeds Module in QuickBooks Online – Part 1

This article addresses some basic tasks of working within the bank feeds module in QuickBooks Online. This module, also known as the “Banking Transactions” module, in QuickBooks Online is a very convenient bookkeeping tool to post transactions in your bookkeeping software. You can also use this function to post credit card, Paypal, loan and lines

Read More

Project Transactions List in QuickBooks Online

This article addresses how to create a project within a customer’s profile in your QuickBooks Online company file. It also addresses how to see that project’s transactions list, also within that customer’s profile. This transactions list is especially helpful for Spec type of home-building projects. This is because Spec type of homes don’t have Profit

Read More

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,

Read More

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

Read More

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