image: img/spreadsheet-templates-cashflow.jpg folder: accounts-and-finance category: template

const config = {
    tabs: true,
    toolbar: true,
    worksheets: [
        {
            worksheetName: 'Cash receipts',
            columns: [
                {
                    type: 'text',
                    title: 'Month',
                    width: '200px',
                },
                {
                    type: 'number',
                    title: 'Starting money',
                    mask: '$ [-]#.##,00',
                    width: '100px',
                    decimal: ',',
                },
                {
                    type: 'number',
                    title: 'Sales',
                    mask: '$ [-]#.##,00',
                    width: '100px',
                    decimal: ',',
                },
                {
                    type: 'number',
                    title: 'Cash injections',
                    mask: '$ [-]#.##,00',
                    width: '100px',
                    decimal: ',',
                },
                {
                    type: 'number',
                    title: 'Expenses',
                    mask: '$ [-]#.##,00',
                    width: '100px',
                    decimal: ',',
                },
                {
                    type: 'number',
                    title: 'Total',
                    mask: '$ [-]#.##,00',
                    width: '100px',
                    decimal: ',',
                },
            ],
            tableOverflow: true,
            tableWidth: '800px',
            data: [
                ['Jan', '0', '526,70', '10000', '=-expenses!E1', '=SUM(B1:E1)'],
                ['Feb', '=F1', '997,50', '0', '=-expenses!E2', '=SUM(B2:E2)'],
                ['Mar', '=F2', '1412,05', '0', '=-expenses!E3', '=SUM(B3:E3)'],
                ['Apr', '=F3', '2074,40', '0', '=-expenses!E4', '=SUM(B4:E4)'],
                ['May', '=F4', '2613,95', '0', '=-expenses!E5', '=SUM(B5:E5)'],
                ['Jun', '=F5', '2015,15', '0', '=-expenses!E6', '=SUM(B6:E6)'],
                ['Jul', '=F6', '3481,60', '0', '=-expenses!E7', '=SUM(B7:E7)'],
            ],
        },
        {
            worksheetName: 'Expenses',
            columns: [
                {
                    type: 'text',
                    title: 'Month',
                    width: '200px',
                },
                {
                    type: 'number',
                    title: 'Purchases',
                    mask: '$ [-]#.##,00',
                    width: '100px',
                    decimal: ',',
                },
                {
                    type: 'number',
                    title: 'Payroll expenses',
                    mask: '$ [-]#.##,00',
                    width: '100px',
                    decimal: ',',
                },
                {
                    type: 'number',
                    title: 'Other expenses',
                    mask: '$ [-]#.##,00',
                    width: '100px',
                    decimal: ',',
                },
                {
                    type: 'number',
                    title: 'Total',
                    mask: '$ [-]#.##,00',
                    width: '100px',
                    decimal: ',',
                },
            ],
            data: [
                ['Jan', '100,50', '1000', '300', '=SUM(B1:D1)'],
                ['Feb', '300', '1000', '250', '=SUM(B2:D2)'],
                ['Mar', '500,75', '1200', '400', '=SUM(B3:D3)'],
                ['Apr', '425,60', '1200', '400', '=SUM(B4:D4)'],
                ['May', '550,10', '1200', '400', '=SUM(B5:D5)'],
                ['Jun', '550,25', '1200', '400', '=SUM(B6:D6)'],
                ['Jul', '700', '1400', '400', '=SUM(B7:D7)'],
            ]
        }
    ]
}