How to complete accounting and bookkeeping tasks with Fusion Accounts, video demonstrations

Click the links below to find out the HowTo answers...

Business

How to activate Foreign Currency?
To activate Foreign Currency go to the ‘Business’ menu and select ‘Business Details’, Scroll to the bottom of the page where you will see the following text ‘Allow Foreign Currency Transactions’. To activate the Foreign Currency tick the box provided and then click ‘Save’ to update the changes. http://www.youtube.com/watch?v=QoPVDjH1tzE
How to create a new user within Fusion Accounts?
To create a new user select the 'Users' tab from the 'Business' menu. Select 'Add User'. Complete the required details and then select 'Create User'. Fusion will automatically create a password for the new user which will be highlighted in the message box. Give this password to the user. After their first login they will then be asked to create a new password and answer a short set of security questions.



Once the user has been created you will then need to assign roles to this user. Tick the box next to the user you have just created and then select 'Roles' from the options above. You can also use the right click on your mouse to view the same list of options.



The 'client admin' role will give the user full access to the system. If there is more than one business you can use the drop down arrow to select the correct business. Users can be assigned different roles for different businesses. Click 'Update' to save the changes.

 

Customers

How to create an aged debtors report?
To create an aged debtors report select the 'Aged Debtors' tab from the 'Customers' menu. The report will show a list of all customers with outstanding debt to your business. The report can be exported to excel or word.

How to record a customer receipt?
You can record a customer receipt in two ways.

1. Select the 'List Customers' tab from your 'Customer menu'. Find the customer by entering the customer name into the 'Name' search field and hit return. Once you have selected the customer click on 'Receipt'. Complete details and select 'Save'

2. Select the 'Customer Receipt' tab from the 'Money In' menu. Find the customer by entering the customer name into the 'Name' search field and hit return. Once you have selected the customer click on 'Receipt'. Complete details and select 'Save'


Note: Remember that you can use the right click function on your mouse each time you select a customer.

How to view the activity of customers? e.g. view their invoices, view a statement of account, etc
You can view the activity of a customer by selecting your 'Customers' menu. To search for a customer simply select 'List Customers'. Enter the customer name into the 'Name' search field and hit return. Once you have selected the customer hit the 'activity' button using the menu above or by using the right click function on your mouse.

You can also view the customers invoices by selecting the customer and clicking on 'List Invoices'

Alternatively you can select the customer and click on 'Customer Statement'

How to update a customers details within Fusion Accounts?
To edit a customers record within Fusion Accounts select the 'List Customers' tab from the 'Customers' menu. To quickly find the customer you are looking for type the first few letters of the customer name into the 'Name' search field and hit return on your keyboard. Fusion will quickly bring up any customers that match your search. To select the customer whos details you want to change tick the box beside the relevant customer. Then select 'Details'. Update the customer record and then select 'Save'

How To post an opening balance.

To post an opening balance against a customer simply create an invoice against that customer to the value of the outstanding balance. Add a line item with the customers opening balance. Select a sales account and a quantity of 1.

For "Cash Accounting" businesses use a T1 VAT code (unless all the transactions were vat exempt) and enter the net and vat amounts, selecting "Override Sales Tax". This is because for cash accounting the VAT becomes due when the invoice is settled.

For "Standard" VAT accounting the VAT code depends on whether all or some of the VAT on the outstanding amounts has already been paid.

For all the invoices whose VAT has been accounted for in previous VAT returns enter the Gross outstanding amount and select T9 (VAT exempt) as the VAT type.

For those invoices that have not had the VAT paid on it then enter another line item, select T1 and "Override Sales Tax". Enter the outstanding VAT amount as the "Manual Tax Amount" and the total outstanding amount less the outstanding VAT amount as the Net Price. Enter a quantity of 1.

We can assist you with posting opening balances if you have them in a CSV format.

Remember, we also offer a complete migration service from Sage line 50.

For further advice email support@fusionaccounts.com or talk to your accountant or book-keeper.

How to create a customer...

To create a customer simply select "Add Customer" from the "Customer" menu.  You can then complete the customer details and save that customer. The customer details are all fairly self explanitory. 

Once the customer details are complet then click on the "Save" button and the customer details will be saved to the database.

 

Notes:

The "A/C Ref" is a reference for your customer.

The "Settlement Days" is the number of days credit that you give this customer.  If this value is not set then the default value for the business is used (which can be set on the Business Detauls page on the Business menu).

 

How to record a customer receipt against a customer account?
To record a receipt against a customers account go to the ‘Customers’ menu and select ‘List Customer’. Select the customer and then use the right click function on your mouse or use the menu above to select ‘Receipt’. If there are any outstanding invoices against this customer they will appear on the right of the screen. If you wish to record the receipt to the customer account then ignore these invoices. On the left of the screen complete the required details, enter in the ‘Transaction amount’ select the bank account and enter in a transaction reference and description. Select ‘Save’ to record the receipt. A message will appear to show the amount the will be allocated to the account and what will be allocated to the invoice. Select ‘Commit’
How to allocate a previously recorded receipt to an outstanding invoice?
To allocate a previously recorded receipt to an outstanding invoice go to the ‘Customers’ menu and select ‘List Customers’.
Select the relevant customer and use the right click function on your mouse, or the tabs above to select ‘Allocate balance to invoice’
At the top of the screen you will see the amount of unallocated funds. Below you will see any outstanding invoices. Using the ‘Amount’ box provided next to each invoice, enter the amount you wish to allocate to the invoice(s).
Select ‘Commit’ to allocate these amounts to the invoices.
How to create a customer report?
To create a customer report go to the ‘Customers’ menu and select ‘Customer Reports’.
Select a financial year and a ‘to’ and ‘from’ date if required.
The report can be run on a single customer, multiple customers or on all customers. You can quickly find a customer by using the search fields provided. To select a customer tick the box next to the customer name. A quick way of selecting all customers is to tick the box present at the top of your screen.
Below you will find a list of reports available. Select ‘Run’ beside the report you wish to run. If you require a report that is not available please do not hesitate to contact us.
Once the report has been generated you can export the report out of fusion by simply choose the required format and clicking on the ‘Export’ button.
Under the ‘Customers’ menu you can also select the ‘Aged Debtors’ tab to run an aged debtors report. Again you can specify dates and periods for the report.

Sales

How to Clone an Invoice?

To clone an invoice select the 'Sales Invoices' tab from the 'Sales' menu. Select the invoice you wish to clone and use the right click function on your mouse or select the 'Clone' tab from the menu above.

How to create a new sales nominal account?
To create a new sales nominal account go to the ‘Financials’ menu and select ‘Add nominal’.
Enter the relevant information using the boxes provided e.g.
  • ‘Nominal Type’ = Sales
  • ‘Nominal Category’ = Choose relevant category or create a new nominal category (see video related to this)
  • ‘Nominal Code’ = Fusion will automatically create this for you
  • ‘Currency’ = Select the currency for the account (only required if Foreign Currency has been activated, see related video)
  • ‘Nominal Name’ = Type in a nominal name
  • Once the details have been entered select ‘Save’ to create the new sales nominal.
How to create and manage products and set stock levels within Fusion Accounts?
To create a new product or edit an existing product select the 'List Products' tab from the Sales Menu

How to record a customer receipt against a sales invoice?
To record a receipt against a sales invoice select the 'Sales Invoices' tab from your Sales Menu. Select the 'Outstanding' tab and then enter the invoice number into the 'Inv Ref' search field and hit return. Select the invoice and then click on the 'Receipt' button. Alternatively you can use the right click function on your mouse.

How to create a Sales Invoice?
To create a sales invoice simply select the 'Add Invoice' link from the 'Sales Menu'. Enter the customers details by using the search box provided. Then complete the sales invoice details. The invoice number will be generated once the invoice has been saved.

Additional fields can be added to sales invoices from the 'Business Details' page.

To select a product or nominal account for the invoice select the 'Add New Item' and once details have been completed select 'Insert'.

If you are happy with the invoice you should select 'Save to Accounts'

How to create a Sales order?
To create a sales order simply select the 'Add Sales Order' from the 'Sales Menu'.

Enter the customer by using the search box provided.

Complete the sales order details. The order number will be generated once the invoice has been saved.

To select a product or nominal account for the sales order select the 'Add New Item' and once details have been completed select 'Insert'.

If you are happy with the sales order select 'Save Sales Order'

How to Email an Invoice?
Select the 'Sales Invoices' tab from the 'Sales' menu. Select the invoice you wish to email. Use the right click function on your mouse or select the 'Email' tab from the menu above. Enter in the customers email address and type a short message and click on 'Send'

If you wish to store an email address against the customer you can do this within the 'Customer Details' section.
How to Print an Invoice?
To print an invoice select the 'Sales Invoices' tab from the 'Sales' menu.

Select the invoice(s) you wish to print and use the right click function on your mouse or use the menu above to select the 'Print' tab.
How to manage Sales Invoices?
You can manage your 'Sales Invoices' by selecting the 'Sales Invoices' link from the 'Sales' menu.

You can view sales invoice in 'Drafts', 'Outstanding', 'Overdue', 'Paid' and 'All'

You can search for invoices using the 'Invoice No', 'Customer Name', 'Date' and 'Amount'

To perform an action against a sales invoice you select the sales invoice and use the right click function on your mouse or use the action buttons provided. You can review an invoice, email an invoice, record a receipt and clone an invoice.

How to create a sales report?
To create a sales report go to the ‘Sales’ menu and select either ‘Sales Reports’ or ‘User Sales Reports’
Within the ‘User Sales Reports’ select a ‘to’ and ‘from’ date if required.
The report can be run on a single user, multiple users or on all users. You can quickly find a user by using the search fields provided. To select a user tick the box next to the user. A quick way of selecting all users is to tick the box present at the top of your screen.
Below you will find a list of reports available. Select ‘Run’ beside the report you wish to run. If you require a report that is not available please do not hesitate to contact us.
Once the report has been generated you can export the report out of fusion by simply choose the required format and select the ‘Export’ button.
How to change the invoice number on sales invoices?

Question : We need our sales invoices to start from invoice number 245. How can we do this within Fusion?

Answer : Under the ‘Business’ menu, select ‘Business Details’ Next to the field titled ‘Next Invoice Number’ enter the invoice number you require. Select ‘Save’ at the bottom of this page.

Question : Our sales invoice reference is alphanumeric. When I create a sales invoice in Fusion it doesn’t appear to let me change the invoice number.

Answer : Sales invoice numbers within Fusion are numeric. You can’t change the invoice number however you can add in an extra field to the invoice so that you can enter the sales invoice reference you require. Under the ‘Business’ menu, select ‘Business Details’ Next to the field titled ‘Invoice Data Field 1 Alias’ enter in your required text, e.g. Our Invoice Ref. Select ‘Save’ at the bottom of this page. When you next create a sales invoice you will see the new field appear. You can then enter in your invoice reference.

Money In

(Receipts) - How to record a general receipt.

If you receive any money that you have not raised an invoice for then this should be recorded as a general receipt.

To record a general receipt select "General Receipt" from the "Money In" menu.  Enter the transaction details such as the date, bank account, Gross Amount, Reference Number, Description etc.

You may optionally override the Tax code and enter the VAT amount manually else it will be calculated for you.

The "Reference" is generally used to identify the transaction on your bank statement - for example the number on the paying in slip - so the bank reconciliation can easily be performed.

Once you have completed the details click on "Record" to record the transaction.

(Receipts) How to record a customer receipt against a customer account?
To record a receipt against a customers account go to the ‘Money In’ menu and select ‘Customer Receipt’.
Select the relevant customer and then use the right click function on your mouse or use the menu above to select ‘Receipt’. You can quickly find a customer by using the search field provided.
If there are any outstanding invoices against this customer they will appear on the right hand side of the screen. If you wish to record the receipt to the customer account then ignore these invoices.
On the left of the screen complete the required details, enter in the ‘Transaction amount’ select the bank account and enter in a transaction reference and description. Select ‘Save’ to record the receipt. A message will appear to show the amount that will be allocated to the account and what will be allocated to the invoice (if any) Select ‘Commit’
http://www.youtube.com/watch?v=2taoUxZWFJA

Money Out

(Payments) - How to record a general payment.

A general payment is any payment from a bank account for anything that we have not recorded as a Supplier Invoice. Supplier invoice payments should be recorded as a Supplier Payment from the Suppliers menu.

To create a general payment select "General Payment" from the "Money Out" menu.

Once the transaction details have been entered then click "Record" to commit the transaction.

Complete the payment details - Currency and exchange rate (foreign currency transactions), the account (bank, credit card or petty cash) that the payment was made from, the date of the transaction, the date of the transaction, a transaction reference, a description, the gross amount, the VAT code.

The transaction reference is usually used to identify the transaction on the bank statement when the bank reconciliation is done. So, typically the check number or reference for an electronic payment is used.

Selecting the override tax code allows the Purchase Tax (VAT) amount to be manually entered rather than automatically calculated.

Suppliers

How to add a supplier.
To add a supplier select "Add Supplier" from the "Suppliers" menu.  Complete the supplier details and click "Save" to save the supplier details.

Bank

How to create a new bank account?
To create a new bank account select the 'Add nominal' tab from the 'Financials' menu.

Enter the details bellow and then select 'Save'

Nominal type = Current Asset

Nominal Category = Bank Account

Nominal Code = Automatically generated

Currency = Select the currency of the bank account

Nominal Name = Type in the name of bank account

Select 'Save'

How to post opening balances on bank accounts.
To post an opening balance on a bank account then you must post a nominal adjustment. Select "Nominal Adjustments" from the Financials menu and click "New" to create a new adjustment.

Set the date for the transaction, the financial year that the transaction should be placed in (usually the current year), enter a reference e.g. O/BAL and a description.

Then enter a nominal adjustment by pressing the add button in the nominal adjustment list and selecting the Bank account from the drop down. Note, like most drop downs in Fusion you can type the first few letters of the account to quickly find it.

Enter the amount in the amount field.

If the bank account is in credit then leave the "Is Credit" unselected. If the bank account is overdrawn then select "Is Credit" Since the bank account is an Asset then to increase the value of the asset we debit the account. This is part of the fundamental accounting magic!

For accounts that are liabilities, e.g. credit card accounts, do the opposite.

You must then create an opposite transaction to another account so that the sum of all the debits and credits are zero. Again, this is fundamental to double entry book keeping.

Create another nominal adjustment and this time select the suspense account, etner the same amount and select the Is Credit box if you debited the bank account.

Your bookkeeper or accountant will zero off the suspense account by creating adjustments to where the money really came from!

Please note - if you have an existing Trial Balance (balance of all your Nominal Accounts) as a CSV please contact the support team as we can easily import it to create opening balances to all your accounts.
How to create a report on a bank account(s)
To create a report on a bank account(s) go to the ‘Bank’ menu and select ‘Bank Reports’.
Select the ‘financial year’ and a ‘to’ and ‘from’ date if required. You can quickly search for a bank account by using the search fields provided. The report can be run on a single account, multiple accounts or on all accounts. To select a bank account tick the box(s) next to the account name. A quick way of selecting all accounts is to tick the box at the top of your screen.
Below you will find a list of reports available. Select ‘Run’ beside the report you wish to run. If you require a report that is not available please do not hesitate to contact us.
Within the report you can use the + sign to drill further into each transaction.
Once the report has been generated you can export the report out of fusion by simply choose the required format and selecting the ‘Export’ button.

Financials

How to access and view all transactions within Fusion Accounts?
Fusion keeps a record of each and every transaction. To view a transaction select the 'Transaction Audit Trail' tab from the 'Financials' menu. You can search for a transaction by entering the 'Transaction Number' the 'Type of Transaction' the 'Date' the 'Amount' the 'Reference' or the 'User' how performed the transaction. Within the transaction audit trail you can 'Edit' or 'Reverse' or 'Export' the transaction. You can also expand each transaction to see the activity behind each transaction.

How to create a new purchase nominal account?
To create a new purchase nominal account go to the ‘Financials’ menu and select ‘Add nominal’.
Enter the relevant information using the boxes provided e.g.
  • ‘Nominal Type’ = Purchases
  • ‘Nominal Category’ = Choose relevant category or create a new nominal category (see video related to this)
  • ‘Nominal Code’ = Fusion will automatically create this for you
  • ‘Currency’ = Select the currency for the account (only required if Foreign Currency has been activated, see related video)
  • ‘Nominal Name’ = Type in a nominal name
  • Once the details have been entered select ‘Save’ to create the new purchase nominal.
How to create a new nominal account?
To create a new nominal account go to the ‘Financials’ menu and select ‘Add nominal’.
Enter the relevant information using the boxes provided e.g.
  • ‘Nominal Type’ = Select Nominal Type
  • ‘Nominal Category’ = Choose relevant category or create a new nominal category (see video related to this)
  • ‘Nominal Code’ = Fusion will automatically create this for you
  • ‘Currency’ = Select the currency for the account (only required if Foreign Currency has been activated, see related video)
  • ‘Nominal Name’ = Type in a nominal name
  • Once the details have been entered select ‘Save’ to create the new nominal.
How to change the name of a nominal account?
To change the name of a nominal account go to the ‘Financials’ menu and select ‘Nominals’
Select the nominal account you wish to edit by ticking the box next to the relevant account. You can quickly search for a nominal account by using the ‘name’ search filter. Once the account has been selected select ‘Amend Nominal’ from the menu above or by using the right click function on your mouse.
Type in the new nominal name you wish to give the account and select ‘Update’ to save the changes.
How to create a new nominal category?
To create a new nominal category within a nominal type go to the ‘Financials’ menu and select ‘Nominal Categories’. Then select ‘Add’. Using the drop down arrow provided select the nominal type you wish the new category to appear under.
Enter in a ‘Category Name’ and then enter a ‘Lower and Upper ref’ to reflect the range of nominal codes that will be associated with this category. Select ‘Save’ to create the new nominal category.
How to change the name of a nominal category?
To change the name of a nominal account go to the ‘Financials’ menu and select ‘Nominal Category’
Select the nominal category you wish to edit by ticking the box next to the relevant account. You can quickly search for a nominal category by using the ‘Category Name’ search filter. Once the category has been selected select ‘Edit’ from the menu above or by using the right click function on your mouse.
Type in the new category name you wish to give the account and select ‘Save’ to save the changes.
How to extend the nominal codes used within a nominal category?
To reset the nominal code range used within a nominal category go to the ‘Financials’ menu and select ‘Nominal Categories’. You can use the search filters provided to quickly search by the nominal type or nominal category.
Select the nominal category that you wish to edit and click on the ‘Edit’ button. Enter in a relevant code to reflect the Lower and Upper Ref you wish to apply to the nominal category. Select ‘Save’ to updates these changes.
How to create financial and nominal reports?
To create a financial report go to the ‘Financials’ menu and select the required report. Financial reports include ‘P&L’, ‘Trial Balance’ & ‘Balance Sheet’. A financial year and date can be selected for each report. The report can be exported out of fusion by choosing the required format.
To create a nominal report go to the ‘Financials’ menu and select ‘Nominal Reports’. Select the ‘financial year’ and a ‘to’ and ‘from’ date if required. You can quickly search for a nominal type or nominal name by using the search fields provided. The report can be run on a single account, multiple accounts or all accounts. To select an account tick the box(s) next to the account. A quick way of selecting all accounts is to tick the box at the top of your screen.
Below you will find a list of reports available. Select ‘Run’ beside the report you wish to run. If you require a report that is not available please do not hesitate to contact us.
Within the report you can use the + sign to drill down further into each transaction.
Once the report has been created you can export the report out of fusion by simply choose the required format and select the ‘Export’ button.
Financials – How to create a new bank account?
To create a new bank account go to the ‘Financials’ menu and select ‘Add nominal’. Enter the relevant information using the boxes provided e.g.
  • ‘Nominal Type’ = Current Asset
  • ‘Nominal Category’ = Bank Account
  • ‘Nominal Code’ = Fusion will automatically create this for you
  • ‘Currency’ = Select the currency of the bank account (only required if Foreign Currency has been activated, see related video)
  • ‘Nominal Name’ = Type in the name of the bank account
  • Once the details have been completed select ‘Save’ to create the new nominal.
twitter youtube channel