<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — Bank Reconciliation Report]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=4763&amp;type=atom" />
	<updated>2014-02-27T19:42:25Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=4763</id>
		<entry>
			<title type="html"><![CDATA[Bank Reconciliation Report]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=19362#p19362" />
			<content type="html"><![CDATA[<p>Hello everyone.&nbsp; I really like Front Accounting and have been using it for a not-for-profit that I work with.&nbsp; I have noticed something about the bank reconciliation report that isn&#039;t obvious at first but it quite tiresome.</p><p>If I perform a bank rec,say in January, and two transactions were not cleared at that date, the report will indicate this by not having a &quot;clearing date&quot; next to it when the transactions are listed for that month.&nbsp; </p><p>The problem becomes apparent on the NEXT reconciliation.&nbsp; Say that there are two more transactions in this rec that have not cleared, and the ones from January have still not cleared.&nbsp; The report will show the CURRENT transactions that haven&#039;t cleared but I have to go back to January to figure out why it still doesn&#039;t reconcile.&nbsp; In month three, this becomes more tiresome and so on. </p><p>Basically a report should just have 3 sections.&nbsp; </p><p>Section 1 - G/L Bank balance compared to Statement Bank balance (the current report does this)<br />Section 2 - Transactions reconciled this month (the current report does this)<br />Section 3 - All un-reconciled transactions up to this month (the current report forgets transactions from previous months! oh no!)</p><p>Example:</p><p>Bank Balance $&nbsp; xxxxxx<br />G/L Balance&nbsp; &nbsp; $ xxxxxx<br />Unreconciled : $ xxxxxx (This is just the difference of G/L and Bank)</p><p>Items Reconciled this month:<br />xxxxx&nbsp; &nbsp; $ xxxxx<br />xxxxx&nbsp; &nbsp; $ xxxxx<br />xxxxx&nbsp; &nbsp; $ xxxxx<br />xxxxx&nbsp; &nbsp; $ xxxxx<br />Total Reconciled this month $ xxxxx</p><p>Outstanding Items (From ALL previous periods where item does not have cleared date)<br />xxxxx&nbsp; &nbsp; $ xxxxx<br />xxxxx&nbsp; &nbsp; $ xxxxx<br />xxxxx&nbsp; &nbsp; $ xxxxx<br />xxxxx&nbsp; &nbsp; $ xxxxx<br />Unreconciled Total $ xxxxxxxxx (this should match from section 1)</p><p>I am going to take a stab at this report but I know basically nothing about PHP. <img src="https://frontaccounting.com/punbb/img/smilies/smile.png" width="15" height="15" alt="smile" />&nbsp; Hoping someone here can maybe modify the one that&#039;s ALMOST perfect.</p>]]></content>
			<author>
				<name><![CDATA[aaron]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=19111</uri>
			</author>
			<updated>2014-02-27T19:42:25Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=19362#p19362</id>
		</entry>
</feed>
