Print an Account Register with separate columns for Payment/Increase and Deposit/Decrease

JWClevenger

How do I print an Account Register that looks like the screen view? That view has the date, payee, Account/Category, memo, Increase/Payment, Decrease/Deposit, and Balance.

I tried to get an Itemized report this morning and finally got one that showed "Expense" and "Transfer" tansactions grouped together. The Expense numbers were exported as labels. It is attached. But I cannot repeat it.

Please help on either solution.

KyAmerWaterItemized.jpg

volvogirl

Did you try customizing the report and adding the columns you want? Check the gear icons at the top.

JWClevenger

I did customize the report to get only the one account. The column selection did not have Increase or Decrease which means they both were there. There was a Balance column. I also specified a 1 year period.

mshiggins

To print a register, open the account to display the register, and press CTRL P.

Jim_Harman

There is no report that includes exactly the same columns as a banking account register. The Ctrl-P or File / Print <account name> method just has Amount and not Payment or Deposit. It does include the running balance.

The "Register report", accessed from the account's gear menu > More reports, is another way to view your account transactions. This is a customized version of the Banking Transaction report, and has the Payee in the Description column. It has an Amount column but not Payment or Deposit. It also does not have the running balance.

mshiggins

@Jim_Harman just tried CTRL P with a checking account in QW2017. The register has payment and deposit columns and the printed report has payment and deposit columns.

Edit to add:

Register is set to 2-line display.

Jim_Harman

Interesting - It appears to be the same in R49.22.

Regardless of the columns selected to display in the register, the columns printed with Ctrl-P in 1-line mode are

Date Num Payee Cat Memo Amt Clr Bal

In 2-line mode it is

Date Num Transaction Payment C Deposit Balance

The Transaction column is a variable number of lines with the Payee in the first line. The following lines have Category and Memo if they are populated. Again it does not depend on what columns are selected to display.

IIRC there was a discussion recently where someone was struggling with the export format when their register was in 2-line mode.

JWClevenger

Thank you all for your comments.

I was able to recreate the report that I was able to use. It was the Itemized Payee report Customized for date and payee. It had Expenses and Transfers by date and subtotaled. Amounts were in the same column when I exported.

The CTL-P or print Transactions report looks like the one attached below. The columns are: DATE, NUM, PAYEE, CATEGORY, MEMO, AMOUNT, C, BALANCE, and S(Split). The amount column shows both increases and decreases(charges and payments) in the same column so it does not look like the register.

KyAmerWaterTransPrint.jpg