Run a Transactions by Account Report in QuickBooks Desktop

Have you ever needed to see an ordered rundown of all your QuickBooks movements? With the QuickBooks review log report, you can monitor added, erased, and changed transactions, just as client sections. The review log permits you to see the history of changes made to singular transactions or the scope of numerous transactions. Followed changes additionally include changes to the diagram of records or items and administrations list; sending, erasing, and altering solicitations or charges, adding and coordinating with installments and deposits, and when accounts run a transaction by account report in QuickBooks. 

Before QuickBooks 2006, clients could delete the review log; notwithstanding, since this time it's anything but a programmed include that can't be incapacitated in either the Online or Desktop forms. For this incredible reporting tool to work appropriately, it's basic that all clients have their significant arrangement filesIffiles attachments word.

See this: How to Delete Multiple Transactions in QuickBooks Desktop?

How to Run a Transactions by Account Report in QuickBooks Desktop?

1. Statement Transaction by Account Report in QuickBooks (Insurance)

Exchanges and sums for the records in your outline of records. Focus on the protection records to see normal month-to-month protection costs.

• Go to Reports.
• Choose Exchange Information by Account in the For My Account area.
• Choose Customize, and afterward choose Filter.
• Pick Distribution accounts, and afterward choose suitable insurance accounts.
• Choose the Run report.

2. Information Transaction by Account Report in QuickBooks (Marketing and Advertising)

Exchanges and sums for the records in your diagram of records. Focus on the promotion and records to see related costs.

• Go to Reports.
• Choose Transaction Information by Account in the For My Account area.
• Choose Customize, and afterward select Filter.
• Pick the Distribution Account, and afterward select the records assigned for showcasing and publicizing.
• Select the Run report.

Also read this: How to Recover Deleted Transaction in QuickBooks?

3. Transaction Information by Account Report (Meals and Entertainment)

Exchanges and aggregates for the records in your graph of records. Focus on the meals and entertainment records to see related costs.

• Go to Reports.
• Choose Transaction Information by Account in the For My Account area.
• Choose Customize, and afterward select Filter.
• Pick the Distribution Account, and afterward select the records assigned for movement, meals, and entertainment.
• Choose the Run report.

4. Transaction Information by Account Report (Liabilities)

Exchanges and aggregates for the records in your outline of records. Focus on the risk records to identify lenders.

• Go to Reports.
• Choose Transaction Information by Account in the For My Account area.
• Choose Customize, and afterward select Filter.
• Pick Distribution Account, and afterward select All Liability Accounts from the drop-down.
• Pick Vendor, and afterward select the proper merchants from the drop-down.
• Choose the Run report.

5. Transaction List by Seller

Exchanges for a while, assembled by the seller. Investigate beyond a while to see repeating patterns.

• Go to Reports.
• Select Transaction List by the seller in the Expenses and Merchants area.
• Choose an announcing period from the drop-down.
• Choose the Run report.

6. Transaction Dues Bills Report

Dues bills, with due dates and days past due.

• Go to Reports.
• Choose Dues Bills in the What you owe segment.
• Choose a reporting period starting from the drop-down.
• Enter your due date.
• Choose the Run report.

Process of Creating the Custom Transaction Detail Reports in QuickBooks Desktop

To ensure that all the transactions recorded by you are done properly, it will need more effort from you. You have to get the total additions and deductions added manually from the statements that are provided by the bank and compare them with the report of Custom Transaction Detail.

To get that done, follow the steps given below:

• Go to the menu bar and choose Reports then Custom Reports and after that Transaction Detail. You will see that the dialog box of the Modify Report opens up.
• Select the dates from the option of From and To, to get the period matched for the reconciling you are doing. If in case it starts from the file’s beginning, then you may have to leave the date of From blank and get the To date entered.
• Tap on the tab of Filters.
• Now in the box of Choose Filter, where the filter of Account is highlighted, select a bank account from the list of drop-downs.
• After that click on OK

Customizing the Transaction Detail by Account report to include journal entries.

• Go to the left panel and then click on Reports
• Get the Report period changed and then click on the button Customize
• Tap on Filter to expand it and then click on the box of Transaction Type and from the list of drop-down, select Journal Entry
• Now from the drop-down menu of Account, select All
• After that tap on the Run Report

Client Balance Information Report

Records of sales by the client. You can sort by the due date to assist with focusing on which clients to contact.

• Go to Reports.
• In the Who owes you section, select Customer Balance Details.
• Choose Run report.
• Choose sort and select to sort by the due date in descending caution.

Payable and Membership QuickReport.

Transaction summary for outstanding and membership accounts:

• Go to Accounting and choose a chart of accounts.
• Sort by dues & membership
• Chooses the run report

Outgoing by Seller Summary

Complete costs for every merchant. You can sort by cost completely to assist with focusing on which merchants to contact.

• Go to Reports.
• Choose Expenses by Seller Summary in the Expenses and Merchant area.
• Choose a reporting time from the drop-down
• Choose the Run report.
• Choose the sort and elect to sort by a sum in descending order.

Open Transaction Report

Neglected invoices and information charges, with aggregates for every client.

• Go to Reports.
• Choose open invoices in the who owes you area.
• Choose the Run Report.

Profit and Loss Report

Income, Expenses, and Net Income.

• Go to Reports.
• Select Profit and Loss.
• Determination Since 90 days before the Report time frame drop-down. Or on the other hand, select Custom and enter a three-month date range.
• In the Display sections by drop-down, select Months.
• Select Run report.

Rent/lease QuickReport

Exchange summary for lease/rent cost.

• Go to Accounting and select the Chart of Accounts.
• Channel by Rent or Lease.
• Select Run report.

Taxable Sales Detail Report

Sales of taxable products and services.

• Go to Reports.
• Choose Taxable Sales Detail in the Sales Charge segment.
• Choose a period from the Report time frame drop-down.
• Choose Month from the Group by drop-down.
• Choose the Run report.
• Go to Settings [add icon] on the report and select Show More.
• Pick the Tax Amount and Tax Name to show the expense organization and how much the customer owes by month.

Total Payroll Cost Report

Costs related to paying workers, including charges.

• Go to Reports.
• Choose Total Payroll Cost in the Payroll area.
• Choose a time frame from the Date Range drop-down.
• Choose the Run report.

Difference Between the Transaction Detail by Account and General Ledger in QuickBooks

Transaction Detail by Account and General Ledger account both provide crucial information related to how money is managed by your company.

A system of double-entry bookkeeping is used by QuickBooks, which requires the offsetting credit in one of the accounts for each debit made in another. Say for example: a debit might be created by you in the Accounts Receivable, where your business looks forward to receiving the credit from the particular account from which the debit was initiated.

If the debit was initiated by the customer, then the credit must offset the debit as soon as you are paid by the customer. Both the report, be it the Transaction Details by Account report or General Ledger report, will allow you to look at the double entries for the account.

The default view of the General Ledger report ensures that you can view the summary of transactions, all of them, for the month that is going on (current month). The ending balance, starting balance, and all the transactions of that period which are organized by the account will be provided by the General Ledger report.

The balance ledger exhibits the equal credit amount for each debit. With a General ledger report, you can quickly get the registers scanned for the unexpected ending balances or for the credits that are posted to the expense accounts as well as debits that are posted in the revenue accounts.

Transaction Detail by Account Reports runs and works mostly in the same way as General Ledger reports work and also provides the same information. Now, unlike the General Ledger report which displays all your accounts, the Transaction by Detail Account report just shows the transaction for one single account.

Typical information that is present in a default Transaction Detail by Account report comprises of transaction’s type, account that is used in the transaction, total, subtotals, and date.

By making use of the drop-down menu of Dates, you can get the period modified, which is displayed in the transaction by Details Account as well as in the General Ledger account.

You can also see the additional information related to the transaction, by just clicking twice on the transaction present in any one of the reports. Reports could also be sorted out by the amount ascending, date, document number, combination of the dates, descending amount, and transactions.

Option of The combined Date/Transaction enables you to keep the line items -all of them related to the single transaction clubbed together.

While looking for the specific transaction, you are allowed by the general ledger to quickly look through all the accounts to identify possible errors. A general ledger report can be used to get the information displayed on every account.

If you can find a suspicious error or transaction, then you can make use of the Transaction Detail by Account report and get the search filter created with the button Customize Report. Limiting the search to a single account can make it easy for you to find the transactions that are needed by you.

Transaction Journal Report in QuickBooks Desktop

A Transaction Journal Report shows debits and credits for each transaction and provides a more focused view of amounts and accounts not visible in the transaction itself.

Purpose of the Transaction Journal Report

• The program was designed for accountants, but anyone familiar with dual-entry accounting can use it for calculations, advanced insight, or auditing.
• Transactions that are out of balance can be identified using it.
• In other reports, it can assist in identifying odd entries.

You may also read this: How to Import PayPal Transaction in QuickBooks Desktop?

How to Access and Use the Transaction Journal

There are multiple methods for accessing the Transaction Journal, depending on the type of transaction being examined. Regardless of the transaction type, there will always be at least one approach that can be utilized.

To access the Transaction Journal, there are several ways depending on the type of transaction being reviewed. These include:

• While on the transaction screen (such as an invoice or sales receipt), go to the transaction toolbar and choose Reports, followed by Transaction Journal.
• Navigate to the QuickBooks Reports menu and select Transaction Journal.
• On a Windows computer, use the keyboard shortcut Ctrl+Y to access the Transaction Journal.
• On a Mac computer, use the keyboard shortcut Cmd+T to open the Transaction Journal.

When using and interpreting the Transaction Journal, there are several key points to keep in mind:

• Accrual basis: The report will always be displayed on an accrual basis, which presents the total value of each entry in the accounts.
• Current transaction only: The Transaction Journal will only show information for the current transaction being viewed, disregarding any filters or dates applied.
• Customizable: Similar to other detail reports, the Transaction Journal can be customized according to specific requirements. Columns and filters can be added or removed as necessary.
• No sorting: The Transaction Journal cannot be sorted, as it will automatically arrange entries based on the order of entry to the transaction.
• Source and targets: The top line of the Transaction Journal represents the source, while the subsequent lines indicate the targets for each entry.
• Non-posting entries: For non-posting transactions (e.g., purchase orders, sales orders, estimates), the Transaction Journal will present debits and credits concerning each account as if it were a posting entry.

Here are some sample scenarios to further illustrate the functionality and application of the Transaction Journal:

• Invoice with inventory parts: When creating an invoice that includes inventory parts, it is expected to see the Cost of Goods Sold and Inventory Asset accounts for the specific item(s) listed. If multiple asset accounts appear, it could be because there are multiple items with different asset accounts.
• Receiving inventory transaction: In the Transaction Journal for a receiving inventory transaction, it is common to see entries for both the Inventory Asset and Cost of Goods Sold accounts. This could be the result of an item having a negative quantity on hand, which prompts QuickBooks to create an adjustment to correct for any losses incurred while the inventory was in a negative quantity state.
• Bill credit for return cost: In situations where a Bill Credit is issued for a return cost that is less than the average cost, an entry for the Cost of Goods Sold will appear in the Transaction Journal. This is because QuickBooks creates entries to track any losses in the background of the credit.

Issues faced by the Users

Is it possible that a report is run for specific customers as well as for their invoices?

If any such question or some other thing is popping up in your mind, then without thinking twice just get in touch with our SMB QuickBooks technical support team. The experienced staff at the SMB QuickBooks tech support helpdesk will extend their support to you. To get in touch with our QuickBooks experts, visit smbaccountants.com.

Frequently Asked Questions