bank reconciliation & split transaction

[Gregory Forster]

Hi Carl,

     Everything you speak of, you can do.  I had to play with this or 
that to get it to do what I wanted.  You sound like you're experienced 
with a GAAP system.  Well, I'm not a CPA, but have been an Enrolled 
Agent for 10 years and am very strong in accounting.  I use to use 
Peachtreee Professional, but got sick and tired of being expected to pay 
hundreds of $ every year.  Personally, I've discovered GnuCash is an 
excellent accounting program.  I'm  sure you realize that setup with 
every program takes time.  But once you're set up, everything is easy.  
It's the same with GnuCash.
Elaborate spreadsheets are very tedious and time consuming to first 
setup, for example, payroll.

     Answering # 3:  Once in GnuCash, Click, Edit/Style Sheets/New. Now 
Enter a shortened version of the entity you are using GnuCash for.  For 
example,  I do the financial accounting for Tri-County Baptist Church.  
So, I entered TCBC in the Name field. I like my reports centered on the 
page, so I chose Fancy for the next box down by clicking the down arrow 
to the right of the box. Click O.K. Another box pops up with a host of 
colors.  I like my reports black and white, not colored, so I modified 
these.  So, going up the box, I clicked on each color.  Another popup 
box appears.  The Red, Green and Blue boxes on the right should have the 
number 255, for white backgrounds.  Click O.K. when you're done with 
that one. Change all the colors to white except the top two, which show 
your text and background as black and white.  Next, choose fonts. 
(Here's where you make your text smaller.) For each category, click on 
the number and choose two sizes smaller.  For example, change all 10s to 
8, all 12s to 10 and 15 to 13.  At least, that's how I did it.  Now, 
when you go to creating a report, say a balance sheet, Click 
Reports/Assets & Liabilities/Balance Sheet/Options.  Select the General 
Tab.  Where you see Stylesheets, select the name of the one you just 
modified.  Your balance sheet will now be centered with smaller fonts.  
You can also use that same style sheet for bank recs, income statements, 
Y/D Income Statements,  general ledgers, etc.

    #1 and #2 take  longer to explain (which I'll do later, if no one 
else beats me to it.)  #4, I'm working on myself and will let you know 
what comparative income statements I came up with.

Greg

On 1/22/2014 6:08 PM, Carl Hofinga wrote:
> 1. I have tried bank reconciliation only once. I do not believe it functions correctly as I would expect it should. Normally, when a bank reconciliation is done, a report can be printed which will show beginning balance, deposits in transit, & un-cleared checks. Then a final balance that agrees with the general ledger. Instead, when finished clearing transactions for the bank statement period, any difference is placed in some type of imbalance account, which then appears in the general ledger. That is NOT correct. You are in balance with ending GL balance because of in transit deposits and checks.
>
> 2. Split – transaction. I believe the way this is programmed is very awkward. When there is already a split transaction (credit card charge for example) for a specific vendor already on record and I now want to enter a new single transaction for the same vendor, that when selecting this same vendor, I get a split transaction line. This then must be deleted in order to enter the single transaction. Not every transaction for the same vendor is a split transaction. More likely it is infrequent. My opinion is that it would be best to display a single line entry each time an existing vendor is selected even though it has had a split transaction previously. Then when a  split transaction for that vendor occurs, “split-transaction” is selected and displays only for that transaction.
>
> 3. My next challenge with GNUCASH is formatting a balance sheet & income statement  report with smaller type and printed lines closer together.
>
> 4. Will GNUCASH someday have a comparative financial report showing 2 different periods -  months or years?
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com