Personal Finance - Zoho DB & Reports Demo Help
  Home Reports Expense Details Income Details
Add New IncomeAdd New Income
Add New ExpenseAdd New Expense
Income trend for the last 12 months
Expense trend for the last 12 months
   
Income split up for the last 3 months (Interactive chart)
Expense Split up for the last 3 months (Interactive Chart)
Reports on Income & Expense Details:
Monthly Income Summary
Categorized Expense Report
Expense Details:
Income Vs Expense Trends
Expense - Payment Patterns
Expense Analysis by Day Of Week
Categorized Income Report
Monthly Income Analysis

The embedded report provides a cross-sectional view of the monthly income data. This report has been created as a Pivot View (How to create a Pivot View ?) in Zoho DB & Reports using the table "IncomeDetails" and embedded here below.

 
Expense details across months categorized by Expense Type

The below report provides the Expense details across months grouped by the Sub-Category of each expense. This report has been created as a Pivot View (How to create a Pivot View ?) in Zoho DB & Reports, using the table "ExpenseDetails" and embedded here below.

 
Income Vs Expense Analysis - Interactive Chart

The below chart describes the income and expense patterns across the months. This interactive chart has been created as a Chart View (How to create a Chart View ?) in Zoho DB & Reports using a Query table created on the tables "IncomeDetails" and "ExpenseDetails".

 
Expense Payment Patterns - Interactive Chart

The embedded chart report provides the payment details and the mode of payment for the expenses made across the months. This report has been created as a Chart View (How to create a Chart View ?) in Zoho DB & Reports, using the table "ExpenseDetails" and embedded here below.

 
Expense Details by the Day of Week

The below chart provides the Expense details by the day of week each expense was made. This report has been created as a Chart View (How to create a Chart View ?) in Zoho DB & Reports, using the table "ExpenseDetails" and embedded here below.

 
Income Details across Months categorized by Income Type - Tabular View

The below Tabular report provides the Income details grouped by income category along with the sum of Income on each category. This report has been created as Tabular View in Zoho DB & Reports, using the table IncomeDetails with grouping based on the column "Category", and embedded here below.

 
Day-by-Day Expense Details for the year 2008 - Demonstrates data fetching from Zoho DB & Reports CloudSQL

The following table provides the Day-by-Day Expense details for the year 2008. This report demonstrates the use of Zoho DB & Reports CloudSQL feature, which enables users to fetch data using SQL SELECT query. The data provided below is fetched by a SQL SELECT query from the ExpenseDetails table.

 
Date Sub-Category Amount Description
05 Apr, 2014 14:16:02 Others $5,000.00
05 Apr, 2014 14:15:40 Others $5.00
04 Mar, 2014 17:09:37 Others $4.00
27 Feb, 2014 16:14:08 Others $10,000.00 10000
14 Nov, 2013 18:10:20 Shopping $232.00
26 Aug, 2013 09:00:12 Others $50.00 hussain
01 Jun, 2013 14:26:47 Bills $25.00 Buy of 10 power addaptors for the office
09 Apr, 2013 13:01:15 Gift $500.00 Very nice gift indeed.
21 Feb, 2013 03:29:28 Bills $399.00
04 Nov, 2012 11:09:35 Shopping $500.00
22 Sep, 2012 12:29:23 Treat $2,000.00 oiluiluil
22 Sep, 2012 12:19:16 Others $100.00 yfh7yujytju7t
30 Aug, 2012 15:12:30 Treat $100.00
14 May, 2012 15:47:30 Trip $2,100.00 Japan Flt.
12 Apr, 2012 17:39:05 Bills $123.45
27 Jan, 2012 14:35:20 Gift $200.00
27 Jan, 2012 14:34:20 Treat $100.00
24 Jun, 2011 09:02:33 Others $100.00 ag
14 Jun, 2011 22:54:11 Shopping $500.00
14 Jun, 2011 22:52:08 Bills $400.00
01 Mar, 2011 13:13:46 Others $50.00
10 Dec, 2010 22:16:07 Others $50,000.00 BMW
09 Dec, 2010 11:47:22 Others $50,000.00
09 Dec, 2010 11:46:12 Bills $50,000.00
05 Oct, 2010 16:13:07 Shopping $1,000.00
19 Sep, 2010 09:38:54 Others $50,000.00
19 Sep, 2010 09:37:03 Gift $1,500.00
05 Aug, 2010 17:12:10 Bills $125.00 Drugs (Hard)
28 Jul, 2010 15:34:51 Others $100.00 testing
30 May, 2010 12:52:43 Shopping $49,999.00
20 May, 2010 22:10:32 Trip $25,000.00
28 Apr, 2010 20:54:07 Others $2,000.00
28 Apr, 2010 20:53:52 Others $100.00
22 Mar, 2010 15:41:58 Others $455.00
12 Mar, 2010 17:58:07 Gift $10,000.00
09 Mar, 2010 22:56:32 Others $49,999.00 raul
19 Feb, 2010 11:05:36 Others $15,000.00
08 Jan, 2010 17:14:12 Treat $20,000.00 new
08 Jan, 2010 17:12:51 Dining $30,000.00 Sub category update
08 Jan, 2010 17:11:34 Others $10,000.00 Time to update
07 Jan, 2010 16:36:43 Gift $1,500.00 bitches ;D
15 Dec, 2009 14:04:12 Others $5,000.00 Yacht rental for week
08 Nov, 2009 11:16:54 Others $5,676.00 cxgdsfv
07 Nov, 2009 11:50:00 Others $330.00
06 Nov, 2009 22:46:48 Bills $432.00 Car
01 Nov, 2009 09:44:23 Others $2,000.00
27 Oct, 2009 09:59:45 Others $1,000.00
16 Oct, 2009 10:48:01 Others $500.00 Russian Girls
15 Sep, 2009 12:45:48 Others $50.00
21 Aug, 2009 14:27:27 Shopping $100.00
03 Jul, 2009 01:50:24 Others $123.00
19 Jun, 2009 14:04:22 Others $30.00
09 Jun, 2009 18:39:53 Bills $23.00
06 Apr, 2009 14:11:43 Dining $1,000.00
23 Mar, 2009 12:32:15 Bills $10.00 dfdf
21 Mar, 2009 12:53:41 Trip $50,000.00 Its a wonderful trip to Seychelles
18 Mar, 2009 17:30:42 Shopping $50,000.00 bajaj pulsar 200cc
16 Mar, 2009 14:36:13 Bills $20.00
08 Mar, 2009 23:54:44 Treat $50,000.00
08 Mar, 2009 23:54:15 Treat $50,000.00
08 Mar, 2009 23:53:32 Others $50,000.00
07 Mar, 2009 13:40:13 Bills $10,000.00
16 Feb, 2009 21:25:16 Treat $2.33
11 Feb, 2009 03:31:09 Others $1,032.00
01 Feb, 2009 03:31:22 Others $321.00
29 Jan, 2009 00:23:37 Others $99.00
22 Jan, 2009 22:45:32 Others $33,333.00
08 Jan, 2009 11:05:50 Others $30,000.00
08 Jan, 2009 11:05:35 Others $25,000.00
08 Jan, 2009 11:04:47 Others $50,000.00
30 Dec, 2008 10:12:32 Gift $300.00
29 Dec, 2008 08:59:10 Bills $500.00
21 Dec, 2008 11:35:16 Others $750.00
06 Dec, 2008 08:30:56 Shopping $20,000.22 sadfsdfsdf
05 Dec, 2008 21:54:29 Bills $50,000.00 Wow
04 Dec, 2008 16:10:28 Others $1.00
04 Dec, 2008 13:55:36 Others $451.00 stefan
04 Dec, 2008 11:17:42 Others $10,000.00
04 Dec, 2008 08:55:46 Treat $25.00
04 Dec, 2008 07:34:56 Shopping $99.00 New Car
03 Dec, 2008 23:36:40 Others $6,788.00
03 Dec, 2008 23:22:05 Others $222.00
03 Dec, 2008 21:37:04 Others $2.00
03 Dec, 2008 15:35:16 Dining $50,000.00
03 Dec, 2008 15:20:22 Others $120.00
03 Dec, 2008 12:25:08 Others $12.00 coffee
03 Dec, 2008 09:44:44 Others $100.00
03 Dec, 2008 08:38:32 Gift $50.00
03 Dec, 2008 06:34:18 Others $22,222.00
03 Dec, 2008 04:31:27 Gift $55.00 This is Great
03 Dec, 2008 00:36:00 Others $50,000.00
02 Dec, 2008 19:19:59 Others $50,000.00 New Car
02 Dec, 2008 16:14:16 Treat $300.00 Lapdancing
02 Dec, 2008 15:45:06 Others $5,000.00
02 Dec, 2008 13:15:16 Treat $50.00 Massage
02 Dec, 2008 11:49:41 Bills $520.00 Telephone bill
02 Dec, 2008 11:40:57 Bills $2,000.00 House Rent
02 Dec, 2008 10:00:33 Bills $25,000.00
01 Dec, 2008 12:15:00 Dining $450.00 Went out for the dinner
10 Nov, 2008 12:11:00 Shopping $1,200.00 Groceries and Interiors
Income Details Table for the year 2008 - Demonstrates a table embedded with Search box from Zoho DB & Reports.

The following table provides all the Income details. This report demonstrates embedding a Table with Search box from Zoho DB & Reports. The embedded table below displays the data from the IncomeDetails table in Zoho DB & Reports.

 
Income Details: