Joomla Bookkeeping comes with a set of reports for free included int he download package.

- Joomla Finance Manager Activity Report
- Joomla Finance Manager Balance Report
- Joomla Finance Manager Customer Purchase Report
- Joomla Finance Manager Products Report
- Joomla Finance Manager Profit and Loss Report

Please remember though, it is designed to be adjustable and able to create/modify your own reports, with it being GPL open source, you can do literally anything you like with it.

If you do make any reports for your system, and would like to share it, to help others and also this system to grow, please let us know and we can add it in.

Description

This is an overview of the Joomla Finance Manager Activity Report on this system.

Please remember though, it is designed to be adjustable and able to create/modify your own reports, with it being GPL open source, you can do literally anything you like with it.

The activity report shows you any transactions that have happened over any given period of time. 

Settings and Location

Make sure the report plugin is enabled, go to Extensions > Plugins, then search in the top for "Activity Report". There are no settings in this report, just enabled or disabled. You can find it under Joomla Bookkeeping > Reports > Joomla Finance Manager Activity Report.

Screen Shots

Activity Report

The information can be displayed in a CSV or on the screen as below

Activity Report output

 

 

 

Bank Transfers Tutorial

Joomla Bookkeeping allows you to move money from one bank account to another, and will automatically update all the transactions accordingly to leave the correct trace.

For this example, I have set up a clean install, and then set up two bank accounts, each with £1000 in. We are going to transfer from the Business Bank Account, to the Business Savings Account, as this is something we do every time we are paid, to save for the tax man.


The next thing we will do, is goto "Transactions" in the main menu and then click on the "Bank to Bank Transfer" button at the top. This will open this little light box window. 


You can see there I have filled it in with some example info, to transfer £100 from my Business Account, into my Savings account ready for the tax man at the end of the financial year. I have also added in a description text, so you can see where this will go in the system later on. This will also allow you to record why you transferred it, because in a year or two time when you look back at this, you will have probably forgotten.

 


You can now see that £100 has moved out of the Business account, and into the savings account, and the comment has been added as a reference to both transactions.

 


And now in the bank accounts you can see that £100 has left the business account and moved to the savings account.

Joomla Bookkeeping will synchronise with Virtuemart, bringing in automatically all the transaction data into your contacts and accounts.

  1. Step one, make sure you have the latest version of everything, Joomla, VirtueMart and Joomla Bookkeeping.
  2. In Transaction Types, make sure you have at least one type being a "Sales Type", and another being "Payment Type". We have added two at the top of the list here, but you can use anything you wish or assign one that is relevant for you.
  3. Make sure the plugin "System - Joomla Bookkeeping Virtuemart Import" is Enabled/Published. It should be, as it is self installed and Enabled when you install Joomla Bookkeeping.
  4. In the same plugin, select the two Transaction Types from above, an example is shown below.

This should be it, now put a test transaction through VirtueMart, and the "Customer" will be created in the "Contacts" area of Joomla Bookkeeping and Joomla Contacts (they are the same thing), and there will be an invoice created with the invoice details on. It will even add into the notes of the invoice, the VirtueMart invoice number, for example "21/07/2017 Order number: EE3U06".