<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[FrontAccounting forum — Bank Reconciliation Report]]></title>
		<link>https://frontaccounting.com/punbb/viewtopic.php?id=4763</link>
		<atom:link href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=4763&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in Bank Reconciliation Report.]]></description>
		<lastBuildDate>Thu, 27 Feb 2014 19:42:25 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Bank Reconciliation Report]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=19362#p19362</link>
			<description><![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>]]></description>
			<author><![CDATA[null@example.com (aaron)]]></author>
			<pubDate>Thu, 27 Feb 2014 19:42:25 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=19362#p19362</guid>
		</item>
	</channel>
</rss>
