It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by MozMan
I just wanted to point out that for the U.S. and Canada, the company I'm associated to has free payroll calculators available. I know it would be more ideal to have a payroll module or something that plugs into Frontaccounting, nevertheless I wanted to post this in case it helps someone.
Canada:
http://helpsme.com/tools/free-canadian-payroll-tax-deductions-calculator
U.S.A.
http://helpsme.com/tools/us-payroll-calculators
Hi Gaston,
If I understand your situation correctly, you want to post a refund and adjust sales taxes accordingly.
Can't you just post a general ledger entry or a bank account payment entry that:
1) Increases your Refunds account (or decreases Sales account)
2) Decreases Sales taxes collected (or increases sales taxes paid)
3) Decreases Cash account
I think that's what I would do.
Hope it helps.
Many thanks for the fix. Looks like it works perfectly now.
I've done some tests and I think I see why this is happening.
We charge taxes on the total including shipping. On the invoices it shows correctly that taxes are calculated after shipping. It seems that in the "Customer Balances" report, the "Charges" field does not add the tax on the shipping to the total amount. This amount is missing which is why the charges column is less than the invoice total when there is a shipping charge.
Maybe I can fix this somewhere in the settings, or maybe it's a bug?
Hello,
In our "Customer Balances" report, the "Charges" column is always a few cents ($0.50, $0.40, $0.65) less than the actual amount invoiced. When the invoice is paid in full, the "Outstanding" column then shows a negative amount (-0.50 etc) and therefore the "Total Outstanding" shows the wrong amount.
We are using two currencies and this only seems to happen with "Customer Balances" reports for customers paying in our "home" currency.
We are using version 2.1.1.
I see version 2.1.5 is available but I haven't read that this is fixed in the news releases. If a later version fixes this please let me know and we'll upgrade.
If you'd like me to explain further or if anything is uncear, please let me know.
Many thanks in advance.
Great! Thanks! Will try it out.
O.K. thank you. So in this case we'll use the "Software Upgrade" link under "Setup" once 2.1 final is released to be on the safe side.
Hello,
A nice little feature would be to have the option to not display voided transactions on reports. This way could have the choice to hide the $0 transactions from journal entry reports for example.
Regards.
Hello,
I know from the update guide that "there are no database changes during a major and minor release. Like from 2.1 to 2.1.1 - 2.1.5".
Sorry if this is a silly question but I'd like to know if there are or will be database changes between the 2.1 beta releases, RC, and final release?
Thanks in advance.
Thanks for fixing it so quickly. It's working well again.
Hello,
Congrats for the release of 2.1RC. It seems the foreign currency transactions no longer work as they do in 2.0.7. I've conducted some tests again and an incorrect balance shows for the foreign currency in the balance sheet. The "Exchange Variance" account seems off also.
Below are the journal entries for the same transactions with the same exchange rates for the two different versions so that you can see what I mean:
2.0.7
http://img99.imageshack.us/img99/7064/s … entrie.jpg
2.1RC
http://img217.imageshack.us/img217/7064 … entrie.jpg
2.1B2 has the same problem as 2.1RC
If you need any additional information from me, please feel free to ask.
Kind regards.
Hi p2409,
I tried using your script to clear up the transactions but I get an error:
"Parse error: parse error in E:\inetpub\path..to..script.php on line 79"
Line 79 is in the section with the table list.
We're using 2.1 beta and php 4
Just wondering if there's I can do to solve this because it would be a handy script.
Thanks!
I second that request. Would be very handy. Or maybe having an option to set the session for a particular date.
I second that notion. Big time.
I think it might already be in progress?
https://frontaccounting.com/wbt/pages/products/the-future.php
Nice, thanks for sharing. For this purpose I've been restoring a clean database but this is a good idea as an alternative.
Kind regards.
I've conducted some test transactions and can say that it looks like everything works perfectly. Thank you again!
Thank you all very much! I've found the file and will try it. It really helps to have such a helpful forum. I will try to contribute to it regularly.
Thanks again for the help. Great that you've found a solution to the matter of the bank transfers.
Sorry to bother you again but I'd like to ask where I will be able to find the files to update? I found the CVS repository (https://frontaccounting.cvs.sourceforge.net/viewvc/frontaccounting/) but I don't know which files to replace.
I ask because we need this functionality before we go live with Frontaccounting as our accounting system.
Thank you!
Thanks for the help. Using different dates for each exchange rate has let the difference in currency value between the dates be posted to the "Realized Exchange Gain/Loss" account" when the customer payment is allocated to the invoice. This is great!
One problem remains. It is when funds are transferred from the USD to CAD bank account on a day that the exchange rate is different from the day the USD funds were deposited.
Let's say there is $100 USD deposited into the USD account on January 1st and the exchange rate is $1.00USD=1.20CAD. The deposit could be from a sale, a loan or whatever. The Balance Sheet will show $120 CAD worth of cash in the USD bank account. The USD "Bank Statement" report will show $100 USD in the account. This makes sense.
Let's say that a day later, on January 2nd the $100USD is transferred from the USD bank account to the CAD bank account. However, on this day the exchange rate is $1.00USD=1.10CAD. The USD bank statement report will show a $0 balance which is correct because the USD was transferred to the CAD account. The balance sheet however still shows $10CAD worth of money in the USD bank account. How could it be that the USD bank balance shows two different totals ($0 and $10) depending on which report you generate? Maybe there's a step I'm missing? Do I have to use the same exchange rate for both dates and then manually credit the CAD account and debit the "Realized Exchange Gain/Loss" account?
I'd love to figure out the proper way to transfer money between accounts and have everything match up. Any help would once again be appreciated.
Hi,
In this example what I did was make a sale to a US customer and billing in USD (at $1.00USD=1.20CAD). Then the payment from the customer is in USD and put in our USD bank account (at $1.00USD=1.00CAD as per your suggestion). The $100 was then "allocated". Finally, the USD funds from our USD bank account are transferred into our CAD account (at $1.00USD=1.10CAD).
You asked "Are you paying a US customer using your USD account?" The answer is:
1) we are billing the customer in USD
2) collecting the payment from the customer into our USD account
3) transferred the collected USD funds to our CAD account
In practice, the three above steps could take place on different dates with different exchange rates. This is what I'd like to figure out how to accomplish properly.
Please let me know if I should clarify further.
Thank you again!
Thanks again t2webby. I've tried what I think you suggested.
1) Created a sale and invoice. In my example, I made a sale of $100USD to a US customer at $1.00USD=1.20CAD
2) Changed the currency rate to $1.00USD=1.00CAD and applied the customer payment.
3) "Allocated" the full amount of the payment $100USD.
4) Changed the currency rate to $1.00USD=1.10CAD (as an example of the rate changing when bank transfer takes place) and made a bank transfer of the $100USD to the CAD bank account.
Still no luck getting anything to show up in the "Realized Exchange Gain/Loss" account. Balance sheet now shows (negative) $-10.00 USD bank balance and an account receivable of $20. USD bank statement shows $0.0 as a balance.
Here are screenshots of the transactions which might help understand my post:
Journal entry report:
http://www.freeimagehosting.net/uploads/th.d34d6ed480.gif
Customer allocations:
http://www.freeimagehosting.net/uploads/th.35de28fe50.gif
Balance sheet report:
http://www.freeimagehosting.net/uploads/th.617e7376f4.gif
Profit and loss report:
http://www.freeimagehosting.net/uploads/th.ac477fd097.gif
USD bank statement:
http://www.freeimagehosting.net/uploads/th.c121b6469a.gif
My System and GL setup:
http://www.freeimagehosting.net/uploads/th.31f3d5141b.gif
Thanks again for your time, greatly appreciated.
Thank you very much for your reply t2webby.
That's right, we have two bank accounts, one in CAD and one in USD. Most of our customers are in the US and pay in USD which we deposit in our USD account. Most of our expenses are in CAD so at some point we transfer some of the USD funds into our CAD bank account.
Initially, I didn't "Allocate Customer Payments or Credit Notes" because I'm not quite sure what the purpose of this is. Maybe you could enlighten me? However, now that I have done it, the financial statements (balance sheet & profit/loss statment) remain unchanged.
I tried a new series of transactions with fluctuating exchange rates, similar to the previous ones. This time I allocated the customer payment after the payment was entered but the financial statements are the same as before. Nothing is posted to the gain/loss account and the balance sheet shows amounts still in Accounts Receivable and some money in the USD bank account while the bank statement report shows $0 in the USD bank account.
Could it be something wrong with my settings somewhere? I went though them carefully but maybe I missed something? Any other clues?
Thanks again.
Hello,
I'm trying to setup FrontAccounting to deal with our situation. We are a Canadian business with both Canadian dollar and US dollar bank accounts. Most day to day activities are done in the Canadian account, no problem. We do collect payments from customers in US dollars and which are deposited in our USD account. I've set up the currencies in the "Currencies" section, the USD bank account, the customer currencies and set up the "Exchange Variances Account" to be our "Realized Exchange Gain/Loss" account on the "System and General GL Setup" page.
Maybe something is wrong but this is what happens when the trasactions take place.
Let's say a customer orders $100 USD worth of items and the exchange rate is 1USD = 1.20CAD. Everything is fine when the invoice is entered, the journal entry report shows Sales of $120 CAD and Accounts receivable of $120 CAD. Let's say a month later the customer pays the $100 USD but the US currency has depreciated such that 1USD = 1.10CAD. The journal entry report will show the USD Bank debit of $110 (in CAD) and the Accounts receivable will decrease by $110 but will still show $10 remaining in Accounts receivable. In other words, $10 CAD in Accounts receivable even though there really is no accounts receiable because the full invoice of $100 USD was paid.
Finally, let's say the exchange rate changed again to 1USD=1.05CAD when the $100 USD cash is transfered to the Canadian bank account using the "Bank Account Transfers" page. The journal entry report will then shows the $105 credited from the USD bank account and the $1.05 debited to the CAD bank account. However, a balance sheet report shows $5 CAD worth left in the USD bank account. A bank account inquiry reort for the USD bank account shows $0 as the ending balance in the USD bank account. So we have one report (balance sheet) saying there's $5 CAD worth of money in the USD bank account and another report (USD Bank Statement) saying there is $0 in the same USD bank account.
To summarize, when it's all done, the Balance Sheet shows:
- CAD Bank Account $105 (fine)
- USD Currency Bank $5 (this should be $0)
- Accounts Receivable $10 (this should be $0)
The "Profit and Loss Statement" shows:
- $120 in sales revenue
- nothing ($0) in the "Realized Exchange Gain/Loss" account.
I'm not sure if or what I'm doing wrong but any help would be greatly appreciated. Sorry for the long post and if it needs clarifying, please let me know.
Thanks in advance.
Hi Froandre,
On each php page, you'll see a variable called "$page_security".
For example:
$page_security = 14;
My understanding is that the number assigned to it sets the security level for that page.
Cheers.
Wow, this is great! Thank you very much.
FrontAccounting forum → Posts by MozMan
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.
