Category:Account/Performing Account Reconciliation - Revision history

Dcowan: update screenshots

2016-06-15T00:08:37Z

update screenshots

Dcowan: added approved do not send invoice status

2016-05-17T02:33:09Z

added approved do not send invoice status

Rlusher: /* Introduction */

2014-12-24T00:57:15Z

‎Introduction

Tyates at 05:33, 9 December 2014

2014-12-09T05:33:19Z

Tyates at 05:32, 9 December 2014

2014-12-09T05:32:43Z

Scarpenter at 01:25, 29 September 2014

2014-09-29T01:25:42Z

Rlusher: /* Performing an Account Reconciliation. */

2014-07-28T07:15:56Z

‎Performing an Account Reconciliation.

Rlusher: /* Performing an Account Reconciliation. */

2014-07-28T07:00:48Z

‎Performing an Account Reconciliation.

Rlusher: /* Performing an Account Reconciliation. */

2014-07-28T06:59:00Z

‎Performing an Account Reconciliation.

Rlusher: Created page with " == Performing an Account Reconciliation. == From time to time you may encounter an accounting error, and need to perform a quick reconciliation on an account without necessa..."

2014-07-28T06:52:34Z

Created page with " == Performing an Account Reconciliation. == From time to time you may encounter an accounting error, and need to perform a quick reconciliation on an account without necessa..."

New page

== Performing an Account Reconciliation. ==

From time to time you may encounter an accounting error, and need to perform a quick reconciliation on an account without necessarily going through every single ledger entry payment. Here is one method you might find useful.

* Go to Finance - > Accounts Receivable > Invoice List.
* Filter on the Account ID, and "Approved" for the invoiced status.
* Take note of the total of the current charges column.

[[File:2014-07-28_16_42_58-Cumulus_-_Finance_-_Accounts_Receivable_-_Invoice_List.gif]]
<br />
* Now go to the Payments Tab. Filter on all "Successful Payments", that are NOT "Internal Charges". Counting Internal Charges will double count credit invoices.
<br />

[[File:2014-07-28 16 46 48-Cumulus - Finance - Accounts Receivable - Payments.png]]
<br />
* Now subtract Payments from Current Charges on Invoices, in this case it will be 73999.68 - 71429.97 = 2569.72.
* This figure should match the fiure

@@ Line 8: / Line 8: @@
 * Take note of the total of the current charges column.
-[[File:2014-07-28_16_42_58-Cumulus_-_Finance_-_Accounts_Receivable_-_Invoice_List.gif]]
+[[File:Finance-accrec-invoice-list-approved-updated.png]]
 <br />
 * Now go to the Payments Tab.  Filter on all "Successful Payments".  Note that when there is an invoice with a credit balance, a debit is applied to the invoice, and the invoice is converted into a payment and marked "internal Charge".  When you are filtering on this tab, if you want to rule these out because you've accounted for them in the invoice tab, make sure in the filter tab that  "Internal Charges" filter is not selected.

@@ Line 10: / Line 10: @@
 [[File:2014-07-28_16_42_58-Cumulus_-_Finance_-_Accounts_Receivable_-_Invoice_List.gif]]
 <br />
-* Now go to the Payments Tab.  Filter on all "Successful Payments", that are NOT "Internal Charges". Counting Internal Charges will double count credit invoices. Also, ensure the ''All Methods'' option is deselected.
+* Now go to the Payments Tab.  Filter on all "Successful Payments".  Note that when there is an invoice with a credit balance, a debit is applied to the invoice, and the invoice is converted into a payment and marked "internal Charge".  When you are filtering on this tab, if you want to rule these out because you've accounted for them in the invoice tab, make sure in the filter tab that  "Internal Charges" filter is not selected.
 <br />

← Older revision		Revision as of 05:33, 9 December 2014
Line 1:		Line 1:
	{{DISPLAYTITLE:Performing an Account Reconciliation}}		{{DISPLAYTITLE:Performing an Account Reconciliation}}
−
	== Introduction ==		== Introduction ==

← Older revision		Revision as of 05:32, 9 December 2014
Line 1:		Line 1:
		+	{{DISPLAYTITLE:Performing an Account Reconciliation}}

−	== ~~Performing an Account Reconciliation.~~ ==	+	== Introduction ==

	From time to time you may encounter an accounting error, and need to perform a quick reconciliation to get the current balance on the account without necessarily going through every single ledger entry payment. Here is one method you might find useful.		From time to time you may encounter an accounting error, and need to perform a quick reconciliation to get the current balance on the account without necessarily going through every single ledger entry payment. Here is one method you might find useful.

@@ Line 18: / Line 18: @@
 * This figure should match the outstanding balance figure on the account summary screen as pictured.
 *It should also additionally match the Ledger Balance on the Transaction tab on the account as pictured.
 [[File:2014-07-28_16_54_35-Cumulus_-_Customers_-_Outstanding_Balance.png]]
 * [[File:2014-07-28_16_57_04-Cumulus_-_Customers_-_Customer_List_-_Transactions.png]]

@@ Line 5: / Line 5: @@
 * Go to Finance - > Accounts Receivable > Invoice List.
-* Filter on the Account ID, and "Approved" for the invoiced status.
+* Filter on the Account ID, and "Approved" & "Approved - Do Not Send" for the invoiced status.
 * Take note of the total of the current charges column.

@@ Line 2: / Line 2: @@
 == Performing an Account Reconciliation. ==
-From time to time you may encounter an accounting error, and need to perform a quick reconciliation on an account without necessarily going through every single ledger entry payment.  Here is one method you might find useful.
+From time to time you may encounter an accounting error, and need to perform a quick reconciliation to get the current balance on the account without necessarily going through every single ledger entry payment.  Here is one method you might find useful.
 * Go to Finance - > Accounts Receivable > Invoice List.

@@ Line 15: / Line 15: @@
 [[File:2014-07-28 16 46 48-Cumulus - Finance - Accounts Receivable - Payments.png]]
 <br />
-* Now subtract Payments from Current Charges on Invoices, in this case it will be  73999.68 -  71429.97 = 2569.72.
+* Now subtract Payments from Current Charges on Invoices, in this case it will be  73999.68 -  71429.97 = 2569.71.
-* This figure should match the fiure
+* This figure should match the outstanding balance figure on the account summary screen as pictured.