Revision [1127]

Last edited on 2008-02-08 13:29:14 by PhilDaintree
Additions:
Certain general ledger accounts can be defined as bank accounts - as many bank accounts as needed can be defined. The following screen is accessed from the Setup->General TAB->Bank Accounts
General ledger accounts defined as bank accounts can be reconciled to bank statements using the matching facilities. Entries made to bank accounts using receipts or payments, also create a total receipt or payment, which is retained for the purposes of matching off the bank statements. Using the bank payments page, general ledger payments can be analysed to any number of other general ledger accounts, but only one entry to the bank account is made. This page also allows payments to supplier accounts to be created. Similarly, using the receipt entry page, a series of receipts from customers which may all have been banked together can be deposited as one amount to a bank account. There is only one amount appearing on the statement as the total of all these receipts, this bank account transaction is created and available for matching deposits off the bank statements. To match payments for example the user clicks on General Ledger TAB of the main menu -> under the transactions TAB of the general ledger menu click on the Bank Payments Matching:
Deletions:
Certain general ledger accounts can be defined as bank accounts - as many bank accounts as needed can be defined.
General ledger accounts defined as bank accounts can be reconciled to bank statements using the matching facilities. Entries made to bank accounts using receipts or payments, also create a total receipt or payment, which is retained for the purposes of matching off the bank statements. Using the bank payments page, general ledger payments can be analysed to any number of other general ledger accounts, but only one entry to the bank account is made. This page also allows payments to supplier accounts to be created. Similarly, using the receipt entry page, a series of receipts from customers which may all have been banked together can be deposited as one amount to a bank account. There is only one amount appearing on the statement as the total of all these receipts, this bank account transaction is created and available for matching deposits off the bank statements.


Revision [1124]

Edited on 2008-02-08 13:03:42 by PhilDaintree

No Differences

Revision [1123]

Edited on 2008-02-08 13:00:14 by PhilDaintree
Additions:
Certain general ledger accounts can be defined as bank accounts - as many bank accounts as needed can be defined.
{{image class="center" alt="Bank Accounts" title="Bank Accounts" url="uploads/ScreenShotUploads/bank_accounts.jpg" }}
General ledger accounts defined as bank accounts can be reconciled to bank statements using the matching facilities. Entries made to bank accounts using receipts or payments, also create a total receipt or payment, which is retained for the purposes of matching off the bank statements. Using the bank payments page, general ledger payments can be analysed to any number of other general ledger accounts, but only one entry to the bank account is made. This page also allows payments to supplier accounts to be created. Similarly, using the receipt entry page, a series of receipts from customers which may all have been banked together can be deposited as one amount to a bank account. There is only one amount appearing on the statement as the total of all these receipts, this bank account transaction is created and available for matching deposits off the bank statements.
Deletions:
Certain general ledger accounts can be defined as bank accounts - as many bank accounts as needed can be defined. General ledger accounts defined as bank accounts can be reconciled to bank statements using the matching facilities. Entries made to bank accounts using receipts or payments, also create a total receipt or payment, which is retained for the purposes of matching off the bank statements. Using the bank payments page, general ledger payments can be analysed to any number of other general ledger accounts, but only one entry to the bank account is made. This page also allows payments to supplier accounts to be created. Similarly, using the receipt entry page, a series of receipts from customers which may all have been banked together can be deposited as one amount to a bank account. There is only one amount appearing on the statement as the total of all these receipts, this bank account transaction is created and available for matching deposits off the bank statements.


Revision [1113]

Edited on 2008-02-08 12:36:45 by PhilDaintree
Deletions:
{{files}}


Revision [1112]

Edited on 2008-02-08 12:35:20 by PhilDaintree
Additions:
{{files}}


Revision [1111]

Edited on 2008-02-08 12:30:06 by PhilDaintree
Deletions:
I think screen shots would be very useful in such how-tos
There is an action that you need to add to a page to allow uploading of files - this shows a form that allows uploads to the uploads directory on the server - files are places in a subdirectory of the uploads directory named after the page in this case ""BankMatching""
%%
{{files}}
%%
{{image class="center" alt="DVD logo" title="An Image Link" url="images/bankmatching.jpg" }}
You can then make links to the file by something like:
%%
{{image class="center" alt="screen shot of bank matching" title="Bank Matching" url="uploads/BankMatching/BankMatching.GIF"}}
%%
The output (that does NOT work for some reason) is shown below:
{{image class="center" alt="screen shot of bank matching" title="Bank Matching" url="uploads/ScreenShotUploads/BankMatching.GIF" link="RecentChanges"}}


Revision [1110]

Edited on 2008-02-08 12:28:34 by PhilDaintree
Additions:
{{image class="center" alt="screen shot of bank matching" title="Bank Matching" url="uploads/ScreenShotUploads/BankMatching.GIF" link="RecentChanges"}}
Deletions:
{{image class="center" alt="screen shot of bank matching" title="Bank Matching" url="uploads/BankMatching/BankMatching.GIF" link="RecentChanges"}}
{{image class="center" alt="DVD logo" title="An Image Link" url="images/dvdvideo.gif" }}


Revision [1109]

Edited on 2008-02-08 12:27:26 by PhilDaintree
Additions:
{{image class="center" alt="trying to insert an image" title="An Image Link" url="uploads/ScreenShotUploads/payments_matching.jpg" }}
Deletions:
{{image class="center" alt="trying to insert an image" title="An Image Link" url="http://www.weberp.org/uploads/ScreenShotUploads/payments_matching.jpg" }}


Revision [1108]

Edited on 2008-02-08 12:19:40 by PhilDaintree
Additions:
{{image class="center" alt="trying to insert an image" title="An Image Link" url="http://www.weberp.org/uploads/ScreenShotUploads/payments_matching.jpg" }}
Deletions:
{{image class="center" alt="trying to insert an image" title="An Image Link" url="uploads/ScreenShotUploads/payments_matching.jpg" }}


Revision [1107]

Edited on 2008-02-08 12:16:21 by PhilDaintree
Additions:
{{image class="center" alt="trying to insert an image" title="An Image Link" url="uploads/ScreenShotUploads/payments_matching.jpg" }}
Deletions:
[[ScreenShotUploads]]
{{image class="center" alt="trying to insert an image" title="An Image Link" url="images/bankmatching.jpg" }}


Revision [1103]

Edited on 2008-02-08 12:11:35 by PhilDaintree
Additions:
[[ScreenShotUploads]]


Revision [1101]

Edited on 2008-02-07 20:01:00 by EmDee
Additions:
{{image class="center" alt="trying to insert an image" title="An Image Link" url="images/bankmatching.jpg" }}


Revision [1100]

Edited on 2008-02-07 20:00:45 by EmDee

No Differences

Revision [1099]

Edited on 2008-02-07 19:55:54 by EmDee
Additions:
{{image class="center" alt="DVD logo" title="An Image Link" url="images/bankmatching.jpg" }}


Revision [1098]

Edited on 2008-02-07 19:54:33 by EmDee

No Differences

Revision [1097]

Edited on 2008-02-07 19:51:41 by EmDee
Additions:
Certain general ledger accounts can be defined as bank accounts - as many bank accounts as needed can be defined. General ledger accounts defined as bank accounts can be reconciled to bank statements using the matching facilities. Entries made to bank accounts using receipts or payments, also create a total receipt or payment, which is retained for the purposes of matching off the bank statements. Using the bank payments page, general ledger payments can be analysed to any number of other general ledger accounts, but only one entry to the bank account is made. This page also allows payments to supplier accounts to be created. Similarly, using the receipt entry page, a series of receipts from customers which may all have been banked together can be deposited as one amount to a bank account. There is only one amount appearing on the statement as the total of all these receipts, this bank account transaction is created and available for matching deposits off the bank statements.
Once all receipts and payments are matched to bank statements, the bank reconciliation statement can be printed which should show how the current general ledger balance reconciles to the bank statement for this account.
Bank accounts are defined from the setup tab from the link to Bank Accounts Maintenance. There is facility to enter the name of the account, the bank account number and the address of the bank if required, as well as selecting the general ledger account to which it refers. There are links to edit existing bank account records and to delete them. However, once defined as referring to a particular general ledger code it is not possible to change the general ledger code of the bank account. This is because there would be entries made to this account. Similarly, if bank transactions have been created using this bank account it is not possible to delete it. The bank account transactions must be purged first (but currently no facility exists to purge bank transactions).
====Bank Account Payments====
From the general ledger tab, the first link under transactions is Bank Account Payments.
The following data is required:
* The bank account from which the payment has been (or is to be) made. A select box allows this to be selected from the list of defined bank accounts.
* The date on which it was paid. This is important since the accounting period in which the payment is entered is determined from the date. The system will default to today's date - this must be changed where bank payments are being entered retrospectively.
* The currency which is being paid. The entries to all bank accounts are made in local currency, but payment to suppliers may be made in foreign currency being purchased in local currency at the exchange rate entered. All bank accounts are recorded in local currency (there is no facility for foreign currency bank accounts). By default the system will use the functional currency of the business as defined in the company preferences page.
* The exchange rate - if the functional currency of the business is being used this should be 1. If another currency is being purchased with the payment then the rate at which it is being purchased should be entered.
* Narrative - applicable to the whole payment. Narrative applicable to individual general ledger entries can be entered separately.
Payments can take two forms - either it is a general ledger payment or it is a payment to a supplier. General ledger payments require an analysis of how the payment should be posted to the general ledger. General ledger accounts can be specified either as the account code directly (if the account code is known) or by selecting from the select box. Any narrative applicable to the general ledger amount can be entered too - and the amount to be posted to the selected/entered account. The total payment is taken as being the sum of all the entries made. If the total of all entries made is negative then this is entered as a negative payment - these are accepted to allow for correction of data entry errors.
====Bank Account Receipts====
The following data is required:
* The bank account to which the payment has been (or is to be) made. A select box allows this to be selected from the list of defined bank accounts.
* The date on which it was paid. This is important since the accounting period in which the payment is entered is determined from the date. The system will default to today's date - this must be changed where bank payments are being entered retrospectively.
* The currency which is being paid. The entries to all bank accounts are made in local currency, but payment to suppliers may be made in foreign currency being purchased in local currency at the exchange rate entered. All bank accounts are recorded in local currency (there is no facility for foreign currency bank accounts). By default the system will use the functional currency of the business as defined in the company preferences page.
* The exchange rate - if the functional currency of the business is being used this should be 1. If another currency is being purchased with the payment then the rate at which it is being purchased should be entered.
* The receipt type, this can be chosen from a drop-down list.
* Narrative - applicable to the whole payment. Narrative applicable to individual general ledger entries can be entered separately.


Revision [1088]

Edited on 2008-02-07 12:07:03 by PhilDaintree
Additions:
{{image class="center" alt="DVD logo" title="An Image Link" url="images/dvdvideo.gif" }}
Deletions:
{{image class="center" alt="DVD logo" title="An Image Link" url="images/dvdvideo.gif" link="RecentChanges"}}


Revision [1087]

Edited on 2008-02-07 12:06:26 by PhilDaintree
Additions:
{{image class="center" alt="screen shot of bank matching" title="Bank Matching" url="uploads/BankMatching/BankMatching.GIF" link="RecentChanges"}}


Revision [1086]

Edited on 2008-02-07 11:56:40 by PhilDaintree
Additions:
{{image class="center" alt="DVD logo" title="An Image Link" url="images/dvdvideo.gif" link="RecentChanges"}}


Revision [1085]

Edited on 2008-02-07 11:52:27 by PhilDaintree
Deletions:
{{image class="center" alt="screen shot of bank matching" title="Bank Matching" url="uploads/BankMatching/BankMatching.gif"}}


Revision [1084]

Edited on 2008-02-07 11:51:12 by PhilDaintree
Additions:
The output (that does NOT work for some reason) is shown below:
Deletions:
The output (that does quite work for some reason) is shown below:


Revision [1083]

Edited on 2008-02-07 11:49:49 by PhilDaintree
Additions:
{{image class="center" alt="screen shot of bank matching" title="Bank Matching" url="uploads/BankMatching/BankMatching.gif"}}
{{image class="center" alt="screen shot of bank matching" title="Bank Matching" url="uploads/BankMatching/BankMatching.GIF"}}
Deletions:
{{image class="center" alt="screen shot of bank matching" title="Bank Matching" url="uploads/BankMatching/BankMatching.jpg"}}
{{image class="center" alt="screen shot of bank matching" title="Bank Matching" url="uploads/BankMatching/BankMatching.jpg"}}


Revision [1082]

Edited on 2008-02-07 01:36:36 by PhilDaintree
Additions:
The output (that does quite work for some reason) is shown below:
Deletions:
The output of this is shown below:


Revision [1081]

Edited on 2008-02-07 01:35:51 by PhilDaintree
Deletions:
{{image url="uploads/BankMatching/BankMatching.jpg"}}
{{image class="center" alt="DVD logo" title="An Image Link" url="images/dvdvideo.gif" link="RecentChanges"}}


Revision [1080]

Edited on 2008-02-07 01:33:56 by PhilDaintree
Additions:
{{image url="uploads/BankMatching/BankMatching.jpg"}}
Deletions:
{{url="uploads/BankMatching/BankMatching.jpg" }}


Revision [1079]

Edited on 2008-02-07 01:33:14 by PhilDaintree
Additions:
{{url="uploads/BankMatching/BankMatching.jpg" }}
{{image class="center" alt="DVD logo" title="An Image Link" url="images/dvdvideo.gif" link="RecentChanges"}}


Revision [1078]

Edited on 2008-02-07 01:29:15 by PhilDaintree
Additions:
There is an action that you need to add to a page to allow uploading of files - this shows a form that allows uploads to the uploads directory on the server - files are places in a subdirectory of the uploads directory named after the page in this case ""BankMatching""
Deletions:
There is an action that you need to add to a page to allow uploading of files


Revision [1077]

Edited on 2008-02-07 01:24:27 by PhilDaintree
Additions:
{{image class="center" alt="screen shot of bank matching" title="Bank Matching" url="uploads/BankMatching/BankMatching.jpg"}}
The output of this is shown below:
{{image class="center" alt="screen shot of bank matching" title="Bank Matching" url="uploads/BankMatching/BankMatching.jpg"}}
Deletions:
{image class="center" alt="screen shot of bank matching" title="Bank Matching" url="uploads/BankMatching/BankMatching.jpg"}}


Revision [1076]

Edited on 2008-02-07 01:23:34 by PhilDaintree
Additions:
I think screen shots would be very useful in such how-tos
There is an action that you need to add to a page to allow uploading of files
%%
%%
You can then make links to the file by something like:
%%
{image class="center" alt="screen shot of bank matching" title="Bank Matching" url="uploads/BankMatching/BankMatching.jpg"}}
%%
Deletions:
I think screen shots would be very useful in such how-tos but I am not aware of any file upload functionality in this wiki - wacko wiki was better in that regard. Just that I couldn't stop the spam with wacko!!


Revision [1075]

Edited on 2008-02-07 01:04:23 by PhilDaintree
Additions:
{{files}}


Revision [1074]

Edited on 2008-02-07 00:56:20 by PhilDaintree
Additions:
Muz, I don't think its an issue getting the system to work this way - there is an interesting dilemma though - on the one hand having the functionality is useless if the pages don't exist and on the other no one will create these pages if the functionality is not there....
However, there is nothing to stop building the pages first and when we get 20 or 30 useful contributions which would be useful whether or not the system is changed and then it really would be of value to have the links coded in the system and we could let the balance of the how-tos be contributed (or not - ok I am sceptical having been around this for a while!).
I think screen shots would be very useful in such how-tos but I am not aware of any file upload functionality in this wiki - wacko wiki was better in that regard. Just that I couldn't stop the spam with wacko!!


Revision [1073]

The oldest known version of this page was created on 2008-02-06 15:47:14 by EmDee
Valid XHTML :: Valid CSS: :: Powered by WikkaWikiGet webERP Accounting & Business Management at SourceForge.net. Fast, secure and Free Open Source software downloads