How to Integrate Bolt.new with Xero

1// .env.local
2XERO_CLIENT_ID=your_xero_client_id
3XERO_CLIENT_SECRET=your_xero_client_secret
4XERO_REDIRECT_URI=https://your-app.netlify.app/api/xero/callback
5
6// lib/xero-client.ts
7import { XeroClient } from 'xero-node';
8
9export function getXeroClient(): XeroClient {
10  return new XeroClient({
11    clientId: process.env.XERO_CLIENT_ID!,
12    clientSecret: process.env.XERO_CLIENT_SECRET!,
13    redirectUris: [process.env.XERO_REDIRECT_URI!],
14    scopes: [
15      'openid',
16      'profile',
17      'email',
18      'accounting.transactions',
19      'accounting.contacts',
20      'accounting.reports.read',
21      'offline_access',
22    ],
23    httpTimeout: 30000,
24  });
25}
26
27// app/api/xero/authorize/route.ts
28import { NextResponse } from 'next/server';
29import { getXeroClient } from '@/lib/xero-client';
30
31export async function GET() {
32  const xero = getXeroClient();
33  const consentUrl = await xero.buildConsentUrl();
34  return NextResponse.redirect(consentUrl);
35}

1// app/api/xero/callback/route.ts
2import { NextRequest, NextResponse } from 'next/server';
3import { getXeroClient } from '@/lib/xero-client';
4
5export async function GET(request: NextRequest) {
6  const xero = getXeroClient();
7
8  try {
9    const tokenSet = await xero.apiCallback(request.url);
10    await xero.updateTenants();
11    const tenants = xero.tenants;
12
13    if (!tenants || tenants.length === 0) {
14      return NextResponse.redirect(new URL('/error?message=no_tenants', request.url));
15    }
16
17    const primaryTenantId = tenants[0].tenantId;
18    const tokenSetJson = JSON.stringify(tokenSet);
19
20    const response = NextResponse.redirect(new URL('/dashboard', request.url));
21    const cookieOptions = {
22      httpOnly: true,
23      secure: process.env.NODE_ENV === 'production',
24      sameSite: 'lax' as const,
25      maxAge: 60 * 60 * 24 * 30,
26      path: '/',
27    };
28
29    response.cookies.set('xero_token_set', tokenSetJson, cookieOptions);
30    response.cookies.set('xero_tenant_id', primaryTenantId, cookieOptions);
31    response.cookies.set(
32      'xero_tenants',
33      JSON.stringify(tenants.map((t) => ({ id: t.tenantId, name: t.tenantName }))),
34      cookieOptions
35    );
36
37    return response;
38  } catch (error) {
39    console.error('Xero callback error:', error);
40    return NextResponse.redirect(new URL('/error?message=xero_auth_failed', request.url));
41  }
42}
43
44// lib/xero-auth.ts
45import { cookies } from 'next/headers';
46import { TokenSet } from 'xero-node';
47import { getXeroClient } from './xero-client';
48
49export async function getAuthenticatedXeroClient() {
50  const cookieStore = cookies();
51  const tokenCookie = cookieStore.get('xero_token_set');
52  const tenantCookie = cookieStore.get('xero_tenant_id');
53
54  if (!tokenCookie || !tenantCookie) {
55    throw new Error('Not authenticated with Xero');
56  }
57
58  const tokenSet = JSON.parse(tokenCookie.value) as TokenSet;
59  const tenantId = tenantCookie.value;
60
61  const xero = getXeroClient();
62  await xero.setTokenSet(tokenSet);
63  await xero.updateTenants();
64
65  return { xero, tenantId };
66}

1// app/api/xero/invoices/route.ts
2import { NextRequest, NextResponse } from 'next/server';
3import { Invoice } from 'xero-node';
4import { getAuthenticatedXeroClient } from '@/lib/xero-auth';
5
6export async function GET(request: NextRequest) {
7  try {
8    const { xero, tenantId } = await getAuthenticatedXeroClient();
9
10    const { searchParams } = new URL(request.url);
11    const statusFilter = searchParams.get('status') ?? 'AUTHORISED';
12
13    const response = await xero.accountingApi.getInvoices(
14      tenantId,
15      undefined, // ifModifiedSince
16      undefined, // where — use status param instead
17      undefined, // order
18      undefined, // IDs
19      undefined, // invoiceNumbers
20      undefined, // contactIDs
21      [statusFilter as Invoice.StatusEnum],
22      undefined, // page
23      false, // includeArchived
24      false, // createdByMyApp
25      undefined, // unitdp
26      false  // summaryOnly
27    );
28
29    const today = new Date();
30    const invoices = (response.body.invoices ?? []).map((inv) => {
31      const dueDate = inv.dueDate ? new Date(inv.dueDate) : null;
32      const daysOverdue = dueDate && dueDate < today && inv.status !== 'PAID'
33        ? Math.floor((today.getTime() - dueDate.getTime()) / (1000 * 60 * 60 * 24))
34        : 0;
35
36      return {
37        id: inv.invoiceID,
38        invoiceNumber: inv.invoiceNumber,
39        status: inv.status,
40        date: inv.date,
41        dueDate: inv.dueDate,
42        total: inv.total ?? 0,
43        amountDue: inv.amountDue ?? 0,
44        amountPaid: inv.amountPaid ?? 0,
45        currency: inv.currencyCode ?? 'USD',
46        contactName: inv.contact?.name ?? 'Unknown',
47        contactEmail: inv.contact?.emailAddress ?? '',
48        daysOverdue,
49        agingBucket:
50          daysOverdue === 0 ? 'current'
51          : daysOverdue <= 30 ? '1-30'
52          : daysOverdue <= 60 ? '31-60'
53          : daysOverdue <= 90 ? '61-90'
54          : '90+',
55      };
56    });
57
58    const totalOutstanding = invoices.reduce((sum, inv) => sum + inv.amountDue, 0);
59    const totalOverdue = invoices.filter((i) => i.daysOverdue > 0).reduce((sum, i) => sum + i.amountDue, 0);
60
61    return NextResponse.json({ invoices, totalOutstanding, totalOverdue, count: invoices.length });
62  } catch (error) {
63    const message = error instanceof Error ? error.message : 'Failed to fetch invoices';
64    return NextResponse.json({ error: message }, { status: 500 });
65  }
66}

1// app/api/xero/reports/pl/route.ts
2import { NextRequest, NextResponse } from 'next/server';
3import { getAuthenticatedXeroClient } from '@/lib/xero-auth';
4
5interface ReportCell {
6  Value?: string;
7  Attributes?: Array<{ Value: string; Id: string }>;
8}
9
10interface ReportRow {
11  RowType: string;
12  Title?: string;
13  Cells?: ReportCell[];
14  Rows?: ReportRow[];
15}
16
17function extractAmount(cell: ReportCell | undefined): number {
18  const val = cell?.Value?.replace(/[^0-9.-]/g, '');
19  return val ? parseFloat(val) : 0;
20}
21
22function findSectionTotal(rows: ReportRow[], sectionTitle: string): number {
23  for (const row of rows) {
24    if (row.RowType === 'Section' && row.Title === sectionTitle) {
25      const summaryRow = row.Rows?.find((r) => r.RowType === 'SummaryRow');
26      if (summaryRow?.Cells?.[1]) {
27        return extractAmount(summaryRow.Cells[1]);
28      }
29    }
30  }
31  return 0;
32}
33
34export async function GET(request: NextRequest) {
35  const { searchParams } = new URL(request.url);
36  const fromDate = searchParams.get('fromDate') ?? new Date(new Date().getFullYear(), new Date().getMonth(), 1).toISOString().split('T')[0];
37  const toDate = searchParams.get('toDate') ?? new Date().toISOString().split('T')[0];
38
39  try {
40    const { xero, tenantId } = await getAuthenticatedXeroClient();
41
42    const response = await xero.accountingApi.getReportProfitAndLoss(
43      tenantId,
44      fromDate,
45      toDate,
46      undefined, // periods
47      undefined, // timeframe
48      undefined, // trackingCategoryID
49      undefined, // trackingCategoryID2
50      undefined, // trackingOptionID
51      undefined, // trackingOptionID2
52      true        // standardLayout
53    );
54
55    const report = response.body.reports?.[0];
56    const rows = (report?.rows as ReportRow[]) ?? [];
57
58    const revenue = findSectionTotal(rows, 'Income');
59    const costOfSales = findSectionTotal(rows, 'Less Cost of Sales');
60    const grossProfit = revenue - costOfSales;
61    const expenses = findSectionTotal(rows, 'Less Operating Expenses');
62    const netProfit = grossProfit - expenses;
63
64    return NextResponse.json({
65      period: { fromDate, toDate },
66      summary: {
67        revenue,
68        costOfSales,
69        grossProfit,
70        operatingExpenses: expenses,
71        netProfit,
72        grossMargin: revenue > 0 ? ((grossProfit / revenue) * 100).toFixed(1) : '0',
73        netMargin: revenue > 0 ? ((netProfit / revenue) * 100).toFixed(1) : '0',
74      },
75      reportTitle: report?.reportName,
76    });
77  } catch (error) {
78    const message = error instanceof Error ? error.message : 'Failed to fetch report';
79    return NextResponse.json({ error: message }, { status: 500 });
80  }
81}