Search options (Page 4 of 5)

Sorry. I might not have been clear but I thought I said "Fees was a great feature" It really makes adding Paypal deposits easy. And yes, I do run a separate bank account for Paypal and add the fees at time of receipt entry.

If you run credit card facilities however, the banks over here charge your fees monthly in one transaction at month end. I think you would do it the same way and only enter the fee to your real bank account when the transaction hit yor real bank account.

When I say one system allowed you to split a bank account, picture a situation that you had $1k of sales per day (mon-fri). That allowed you to enter receipts of $5k for  the whole week and split it into the 5 transacations when reconciling. There were times where this was extremely useful. From memory, I devised an automated system where I could import a week's worth of receipts from the front office system into the GL and then split each bank deposit off the total when reconciling.

The FA solution using separate accounts is still a workaround to the real process. A good bank deposit listing with a set of payment types (eg, cash, cheque, credit card, Amex etc) applied when each receipt is entered would be superior would mean that the need to manually select the Credit card bank account and then make the subsequent transfers would disappear.

You get my vote for direct invoicing and maybe you could sweet talk Tom into modifying his OsCommerce module to add a "Change OsCommerce Order Status" button. Purpose of button would be to send data back to OsC about order status. eg. Delivered/Invoiced etc.

There in an interesting interoperability standard in the printing industry called JDF (Job Definition Format) and buried in that is another standard called JMF (Job Messaging Format) JMF is designed to do exactly what you guys want to do. send a message back to another system to change a job status (eg. from order to delivered to invoiced). The JMF message is a small packet of XML usually either sent to a hot folder ot posted to a URL.

If such an interoperability standard was developed for the current OsC extension, it would be a great base to develop a standard for these sort of updates, particularly if it avoided direct table updates and relied on a interoperability mechanism.

I think the OSC part would be a fairly small project but a step in the right direction.

Somebody might clarify this as I am still a noob, but my understanding is that thet is the puropse of doctext2.inc. If Dutch is your default currency, then invoices in another currency use the text in doctext2.inc That way, If you print an invoice in the French currency, it will ues the descriptions in doctext2.inc. You find it in the includes directory under the reports folder.

Glad I could help clarify this issue.

Joe, my thinking was that if you ran another bank account as a "Till" you would add all deposits your customers make to that account. Then you could run the currently non-existent Bank deposit report on the till. When you made a deposit to your bank which would satisfy their requirements and then create a transfer from the Till to your bank account which would enable the real bank account deposits to be reconciled. Still a bit of a workaround, but pretty simple and workable.

I do something similar with a Paypal Account and I might add the ability in FA to add a bank fee at the time of the transfer is a great asistance. Previously (different ssystems), I had to post a payment for paypal fees.

Itronics, I think the need for a bank listing report mechnism is still required to deal with debit card and credit card transactions. If you have a terminal from your bank to accept these payments electronically, they will be consolidated into one depost on the bank account. Most systems I have used have the concept of a payment type to suport this. So when you receive a payment you set the payment type and it is consolidated accordingly when posted to the bank to simplify reconciliation.

In my case, I have only written about 2 cheques in 4 months of trading and all of my deposits have been via Paypal or Direct deposit.

I might add that one system I used also had the ability to split off deposits so you could post one figure for say a week's sales and then split off the daily bank deposits from this gross amount when your book keeper came in for his weekly visit Thiswas the most awesome feature!

OK I got it, been working with 2.2.6 (why is it tat every time I install an open source product, a new version issues the next day?)

Header2.inc needs following changes

doctext.inc needs the following change right at the top of the file

Sorry Notepad does not count lines!

I don't think the Name of your company (coy_name) should be printed in the delivery address. A lot of companies eg a building suupply company would have the same requirement to ship to a totally different address. eg.  A builder orders building material that is delivered to my front lawn for a job he is doing for me.

OK, this is 1st effort ever at PHP, looking at this, it looks like:
1. Ammend function get_po($order_no) in rep209.php to retrieve the delivery address from PO as it does not seem to be in the SELECT statement.
2. Print the address in header 2.inc. I think that should be done by modifying this block:

if ($sales_order != NULL)
        {
            $this->row = $temp;
            if ($doctype == ST_PURCHORDER)
                $this->Text($mcol, $this->company['coy_name']);
            elseif ($doctype != ST_SUPPAYMENT && isset($sales_order['deliver_to']))
                $this->Text($mcol, $sales_order['deliver_to']);
            $this->NewLine();
            if ($doctype != ST_SUPPAYMENT && isset($sales_order['deliver_to']))
                $this->TextWrapLines($mcol, $this->rightMargin - $mcol, $sales_order['delivery_address']);
        }

3. Change Description in doctext.inc for the right hand text block to "Deliver to"

However, I see the delivery address is being printed for ST_SUPPAYMENT. Is that being retrieved elsewhere in which case I can skip step 1? That would be nice and easy!

Is there a list of report numbers somewhere? being able to find the  ST_SUPPAYMENT report would be a great help

I don't think the bank statement report addresses Joe's problem. I think what he wants is a list of the cheques he is depositing when he goes to the bank to make a deposit of his hard earnt takings...

Normally, that would have columns for
Drawer, *Bank, *Branch, Amount

I don't think we capture the data marked witth an * in FA though

Perhaps companion reports to the bank statement called:
"Bank Payments Listing" and "Bank Deposits Listing"  which just listed the appropriate transactions with a total would go a fair way towards addressing Joe's problems.

Joe, furthermore I think you would need another bank account for your "Till" and transfer the balance from the Till bank account to your real bank account when you make a deposit.

Paul

I had no problems with installing the Aussie Chart on version 2.2.6 which is the current version.

I think you downloaded the 2.1 version. The 2.2 version modified by Joe after I reported problems (1 March 2010) can be downloaded from here:

https://frontaccounting.com/wbt/pages/d … ts-2.2.php

The problem I reported to Joe is on this thread. I show the bits I deleted from the SQL file which I applied using MySQLAdmin

https://frontaccounting.com/punbb/viewtopic.php?id=1148

Make sure you make a backup copy of the MySQL Database. I didn't and had to reinstall FA again. Once I had a backup, I was able to replace the tables when I was locked out and try again.

I personally think the better approach is not to touch the security_roles and user tables at all so I would delete the blocks I showed before running ths scripts.

If you agree this is the best way to go then post up on the other thread and ask Joe to amend the chart again.

I have got all my data in since I established a business in October and it works well.

Joe has posted my AU language files here:
https:/sourceforge.net/projects/frontaccounting/

And you might like to look at this thread on the Aussie bank payment system here:

https://frontaccounting.com/punbb/viewtopic.php?id=1153

With all this customisation, you will be just about set with FA!

Joe I think we are thinking of (well I was anyway) of something like

Anyway, you'll get the drift of my peudo-code...

I can see that people would like to have a choice here. From my brief experience with FA, this does not sound too hard to achieve as it is only a change to report format and the reports are mainly contained in the one file aren't they?

Perhaps there was a global flag that allowed user to toggle between the current report and the format proposed by shopimport? There may also need to be a couple of screen updates that would also respect the state of this flag..

This was great work and I spent most of my day in this module yesterday entering 4 months data for my country. The bank rec worked flawlessly.

Another reason we need a bank reconcliation is that if we take our trial balance to an external accountant to prepare our books and tax returns at year end is that he will want to see a bank reconciliation report to demonstrate that all of our data is included.

So what about a Bank Reconciliation Summary Report to take to him?
I hope I get this right - Something like:

1. Bank statement closing balance: $xxx

Add: Unpresented Payments:
Payment 1 $xxx
Payment 2 $xxx
...
Payment n $xxx
2. Total Unpresented Payments   $xxx

Less: Unpresented Deposits:
Deposit 1 $xxx
Deposit 2 $xxx
...
Deposit n $xxx
3. Total Unpresented Deposits $xxx

4. Calculated Reconciled Balance (1+2-3) $yyy
5. Cashbook Computer Balance $yyy

6. Difference (4-5) $0.00

I wish I knew how to program in php or I would have a go at this. I guess you would need to select the bank account and reconciliation date (from the drop down in the existing bank rec) befre printing the report.

It is nice to be able to attach this report to each bank statement and your accountant will get really excited and start recommending FA to his clients!

I have not got this far and am entering data for a new business. But  normally with accounting systems, you would set the commencement year to be the previous financial year.

Then enter opening balances for AR and AP in the customer and supplier accounts but post the values against the respective GL accounts for creditors and debtors. At the end of this process, your trial balance should be NIL but the customers and suppliers have balances in them.

Then you would simply post the balances from the trial balance via the GL. Once this is done, close off the financial year and you are ready for the current financial year.