26

(4 replies, posted in Setup)

I have updated my setup with the new account.

Is there any way I can move the values currently stored in the carriage account to this new shipping account so everything is correct?

I think the Journal Entry page might be able to do it but am not quite sure what I need to add to keep everything correct?

Currently I have 11.50 credit in the carriage account but would like to move this to the new shipping account.

Do I just debit the carriage account with 11.50 and credit the shipping account with 11.50?

27

(4 replies, posted in Setup)

I have set the Shipping Charged Account in System and General GL Setup to 5202 (Carriage) in my setup using English - Great Britain - General chart of accounts.

This carriage account is under the Cost of Goods Sold category which is of the class Costs, Cost is of type expense.

I am just wondering if this is the correct account I should be using for the Shipping Charged Account?

28

(8 replies, posted in Setup)

Yes, I will make these changes as suggested.

Two more small changes I missed:

Display Setup -> Date Format change to DDMMYYYY
Display Setup -> Page Size change to A4

I think this is everything.

29

(8 replies, posted in Setup)

Here is a list of everything I have changed from the default import of English - Great Britain - General chart of accounts:

GL Account Groups -> CURRENT LIABILITIES: set to Liabilities

System and General GL Setup -> Retained Earnings: add account 2331 (Retained Earning) in Long Term Liabilities

System and General GL Setup -> Profit/Loss Year: add account 8601 (Profit/Loss Year) in general and administrative expenses

System and General GL Setup -> Bank Charges Account: change to 7901 (Bank Charges) in general and administrative expenses

System and General GL Setup -> Shipping Charged Account: change to 5202 (carriage) in cost of goods sold

Sales -> sales areas: change USA to UK

I think this is everything I have changes from the default install so there is not too much to modify on the English - Great Britain - General chart of accounts.

I hope this helps.

30

(8 replies, posted in Setup)

Hi Joe,

I did think it was a little odd that CURRENT LIABILITIES was set as Assets, I will change this over and move the Retained Earnings to LONG TERM LIABILITIES as suggested. This was how the English - Great Britain - General chart of accounts set everything up when I imported it.

I think it would be quite handy if these setting were updated on the English - Great Britain - General chart of accounts for the benefit of people like me who are not quite sure what everything is for.

I think there are only a few changes to be made to the English - Great Britain - General chart of accounts as most of the other settings seem to be correct.

If it is of any use I can post a list of all the settings I have had to change from the default English - Great Britain - General chart of accounts install?

Thanks for your help once again.

31

(8 replies, posted in Setup)

Thanks for the information.

I found a bank charges account in the General and Administrative Expenses section.

Profit/Loss Year I added to the bottom of the General and Administrative Expenses section as suggested.

The Retained Earnings I added to the Current Liabilities section - I was not quite sure about this one though as there is also a Long Term Liabilities section.

The CURRENT LIABILITIES is of class type Assets
The LONG TERM LIABILITIES is of class type Liabilities

Which of the two should Retained Earnings be added to as I am not sure I have it in the correct one.

Thanks for your help.

32

(8 replies, posted in Setup)

I am now using Front Accounting for real, I have been testing it for a while, I have everything setup and all my products and suppliers added.

I am using the English - Great Britain - General chart of accounts and there are three things I am not sure about:

Retained Earnings
Profit/Loss Year
Bank Charges Account

All these have defaulted to the Freehold Property option but this is not correct.

Could someone suggest the correct / most relevant account these should really point to?

Yes, that fixed it!

I went to Setup -> Points of Sale and edited my POS and the Allowed Credit Sale was no longer ticked. I ticked it and updated and the Payment drop down appeared on the Direct Invoice page.

Thanks for your help with this, it is much appreciated.

I have version 2.2.5 installed and have set a customer to have Payment Terms of Due 15th of the Following month but on the Direct Invoice page I do not see the Payment option, just the Price List drop down, this only allows for an instant cash sale.

Is there another setting somewhere that I need to change to make the Payment Option drop down appear?

(I am using the English - Great Britain - General chart of accounts)

Ok, that explains it.

I don't know much about accounting so I am just trying to workout where all the figures come from and what they mean.

I have set up a test site now and am using it as a trial run, I am planning on using it properly from the start of the next tax year.  Basically I have been working out how much profit I have made, how much I have spent etc and then seeing how this corresponds to the various reports.  This way I have been learning about all the accountancy things as I go and what reports are relevant to me.

Thanks for the help.

When I do a profit and loss report I get a positive calculated return but when I do a balance sheet report I get a negative calculated return.

Is this also the reason for the total assets on the balance sheet showing as zero?

Balance Sheet:

CURRENT ASSETS     518.86
CURRENT LIABILITIES     90.14
Calculated Return     -609.00
Total Assets     0.00

Profit and Loss report:

Total Income 950 950 100.0
Total Costs 341 341 100.0
Calculated Return 609 609 100.0

37

(9 replies, posted in Accounts Payable)

Yes, that has fixed it!

Thank you very much for looking in to this today, it is much appreciated.

I can now start to set up for real, I have been working out how to use Front Accounting for my business on a demo for a month or so but now am ready to start using it properly - this was the last issue I was trying to resolve.

Thanks again.

38

(9 replies, posted in Accounts Payable)

I have been experimenting with this this afternoon but as you say the shipping is unknown until my supplier issues their invoice and I really want to add my purchase orders as I get them and not have to go back and edit them.

I am sure this must be possible as I would have thought this is a fairly common occurrence as all my suppliers have invoices in this exact format.

I am sure there is a way to do this but so far I have not found it.

The closest I have got so far is this but it seems to have the wrong figures:

Two Quick Entry Lines set at:

Taxes added (10%)
Remainder     (4430 Shipping & Handling)

When I add a £10 quick entry the sub total is correct at £10 but the tax line (10%) shows £100 instead of £1.00.  I am not sure where the £100 comes from?  The total is then shown as £110.

It looks like the £10 is being multiplied by 10 rather than 0.1 on the tax line?

39

(9 replies, posted in Accounts Payable)

Hi Joe,

Thanks for your help with this.

What I am trying to achieve is the following (tax set at 10%):

I enter a shipping amount in the quick entry, say £10

In the subtotal box I see £10
In the tax box I see £1.00
In the total box I see £11.00

Having it set up in this way would match my suppliers invoices exactly as they show everything excluding tax. They have products and shipping excluding tax as a subtotal, the relevant tax from products and shipping next in the tax box and then the main total.

This way means I can directly copy my suppliers figures straight in from their invoices and my invoice will then match theirs.

I have been trying many different combinations of remainder, amount, taxes added and taxes included but am not able to get one to show the results as above.

40

(9 replies, posted in Accounts Payable)

I have been trying various combinations of Quick Entry Lines but have not found the correct ones.

The closest I have got is by having two Quick Entry Lines:

Remainder
Taxes included

I have set the tax at 10% for testing purposes.

If I now add £10 as a shipping Quick Entry I get two GL Items for this Invoice lines:

£10
£0.91

The subtotal shows the £10 which is correct but the tax shows £0.91 which is not 10% of £10.

What I am aiming for is £10 subtotal and £1.00 tax to give a total of £11.00

41

(9 replies, posted in Accounts Payable)

I am just trying to work out the best way to add shipping on to a supplier invoice.

On the invoice I can add the products and they show the relevant tax in the tax row but I am just trying to figure out the best way to add the shipping.  I can create a new Quick Entry called shipping but then this is not shown as part of the tax row, it just adds directly to the total.

What I am ideally trying to achieve is to add shipping excluding tax (like products) and have the tax added on the tax row along with the products tax.

I have been trying the various Quick Entry options but have not managed to come up with a combination of Quick Entry Lines that works in this way.

42

(1 replies, posted in Items and Inventory)

I have a quick question about sales kits:

I made a sales kit and added a few items to it. When I create a sales order and choose the kit and add it the price is set to zero for all items. If I set a price for the kit on the sales order and add it the price is divided between all the items.

If I decide I actually want the real price for the items in the kit to be used rather than the manually added price I just toggle the drop down for retail / wholesale and the actual prices are added.

Is this how I should be doing this, for me it works perfectly as I want to use the real items prices not the divided ones but I was just wondering if this is how it should actually be used.

43

(2 replies, posted in Reporting)

Yes, I see now - I did not realise that each process (sales order, delivery and invoicing) could have a separate reference number, I was thinking the reference number was for the entire chain of events and was the same for each process.

I will keep on using the demo until I figure everything out.

Thanks for your help.

44

(2 replies, posted in Reporting)

When I added a sales order I added a reference and a customer reference. When I viewed the PDF sales order the reference is at the top under the date as 'order number', the customer reference is at the top of the table under 'customers reference' but there is an additional field called 'our order no'. Should this contain the reference number? If not what is it for and where do you set it?

I have been testing this on the demo site but have not been able to get anything to appear in this box.