Skip to content
JQuickJQuick

Audit working paper — generate this PDF with Java (Template)

JQuick-PdfBanking Demos

Template2 页 A4 · 31 KB

Audit working paper / confirmation receipt.

Download the PDFView raw template fileBack to all demos

Audit working paper — Template
Rendered output

Output specs

PDF pages
2
Chart type
Template
Template lines
183
Source lines
207

Java source · JQuickBiz151AuditWorkingPaper.java

This is the complete test class that produced the PDF above — copy it and run as-is; see the quick-start section for the Maven dependency.

/*
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 *
 * Copyright (c) [2025-2099] Martin ([email protected])
 */
package com.github.paohaijiao.biz.bank;

import com.github.paohaijiao.config.JPdfConfig;
import com.github.paohaijiao.executor.JQuickPdfFactory;

import java.io.File;
import java.io.IOException;
import java.math.BigDecimal;
import java.nio.file.Files;
import java.util.Arrays;
import java.util.LinkedHashMap;
import java.util.Map;

/**
 * 单据 151：金融审计工作底稿 / 函证回执单（bank 领域第 12 项）。
 *
 * <p>本类为独立可运行 Demo：自带 {@code main} 方法、不依赖任何公共工具类或实体类，
 * 数据以 key-value 形式通过 {@link JQuickPdfFactory#bindAll(Map)} 注入，
 * 版式全部落在模板文件 {@code demo/biz/bank/151_audit_working_paper.txt} 中。</p>
 *
 * <p>视觉主题「绛紫·素雅·下线」：主色 #4D246B、辅色 #869127、浅底 #F4F1F6；
 * 版式为 underline 抬头 + kv 信息区 + light 明细表 + right 签章区 + table 落款，
 * 与同领域其它单据互不重样。</p>
 *
 * <p>金融审计工作底稿 / 函证回执单：底稿索引与被审计单位、函证编号与被函证单位，</p>
 * <p>逐项函证项目（账面、回函、差异）与审计结论、编制复核签章栏。</p>
 *
 * <p>运行后输出：{@code D:/test/pdf/151_audit_working_paper.pdf}。</p>
 *
 * @author Martin
 * @version 1.0.0
 */
public class JQuickBiz151AuditWorkingPaper {

    private static final String PDF_DIR = "D:/test/pdf/";
    private static final String OUT_FILE = PDF_DIR + "151_audit_working_paper.pdf";
    private static final String TEMPLATE = "demo/biz/bank/151_audit_working_paper.txt";

    /** 模板固定明细行数，不足时补空行，避免占位符原样输出。 */
    private static final int ITEM_ROWS = 6;

    public static void main(String[] args) throws IOException {
        new File(PDF_DIR).mkdirs();

        // ---------- 1. 数据（无实体类，直接 bind）----------
        String[][] items = {
                {"1", "银行存款 — 基本户", "1652918.30", "1652918.30", "0.00", "邮寄原件", "相符"},
                {"2", "银行存款 — 一般户", "386420.55", "386420.55", "0.00", "邮寄原件", "相符"},
                {"3", "银行存款 — 保证金户", "500000.00", "500000.00", "0.00", "邮寄原件", "相符"},
                {"4", "短期借款 — 流贷", "1300000.00", "1300000.00", "0.00", "邮寄原件", "相符"},
                {"5", "应付票据 — 银承", "1186000.00", "1186000.00", "0.00", "邮寄原件", "相符"},
                {"6", "或有事项 — 保函", "1860000.00", "1860000.00", "0.00", "邮寄原件", "相符"}
        };

        Map<String, Object> data = new LinkedHashMap<String, Object>();
        data.put("indexNo", "A-3-2 / 银行存款函证");
        data.put("prepareDate", "2026年10月27日");
        data.put("firmName", "××会计师事务所（特殊普通合伙）");
        data.put("companyName", "××智能装备制造有限公司");
        data.put("auditPeriod", "2026年01月01日 — 2026年09月30日");
        data.put("auditItem", "银行存款余额及银行借款函证");
        data.put("confirmNo", "CONF-2026-A3201");
        data.put("confirmee", "中国建设银行××支行");
        data.put("preparerInfo", "柳文渊 / 闻仲平");
        data.put("pageInfo", "本底稿共 3 页，第 1 页");
        data.put("conclusion", "经函证，上述银行存款与银行借款账面记录与银行回函一致，未发现重大差异，可以为审计意见提供充分、适当的审计证据。");
        data.put("preparer", "柳文渊");
        data.put("reviewer", "闻仲平");
        data.put("confirmeeSign", "中国建设银行××支行");

        // 明细逐格展开，并累计金额
        BigDecimal itemTotal = BigDecimal.ZERO;
        for (int i = 0; i < ITEM_ROWS; i++) {
            int n = i + 1;
            if (i >= items.length) {
                data.put("itemName" + n, "—");
                data.put("itemSpec" + n, "—");
                data.put("itemUnit" + n, "—");
                data.put("itemQty" + n, "—");
                data.put("itemPrice" + n, "—");
                data.put("itemAmount" + n, "—");
                data.put("itemTax" + n, "—");
                continue;
            }
            data.put("itemName" + n, items[i][0]);
            data.put("itemSpec" + n, items[i][1]);
            itemTotal = itemTotal.add(new BigDecimal(items[i][2]));
            data.put("itemUnit" + n, items[i][2]);
            data.put("itemQty" + n, items[i][3]);
            data.put("itemPrice" + n, items[i][4]);
            data.put("itemAmount" + n, items[i][5]);
            data.put("itemTax" + n, items[i][6]);
        }

        data.put("totalAmount", itemTotal.setScale(2, BigDecimal.ROUND_HALF_UP).toPlainString());
        data.put("totalAmountInWords", toChineseAmount(itemTotal));

        data.put("confirmTotal", itemTotal.setScale(2, BigDecimal.ROUND_HALF_UP).toPlainString());

        data.put("totalLine", "账面金额合计（大写）" + toChineseAmount(itemTotal) + "　　（小写）￥" + itemTotal.setScale(2, BigDecimal.ROUND_HALF_UP).toPlainString());

        // ---------- 2. 渲染 ----------
        JPdfConfig config = new JPdfConfig();
        config.getLayoutConfig().setFlexLayout(true);
        config.getDoc().setMargins(Arrays.asList(48, 48, 48, 48));
        config.getFontConfig().setDefaultFontName("Noto Sans CJK SC");
        config.getHeaderConfig().setEnabled(true);
        config.getHeaderConfig().setText("××会计师事务所　审计工作底稿　A-3-2 银行存款函证");
        config.getHeaderConfig().setFontSize(8f);
        config.getHeaderConfig().setHeight(34);
        config.getFooterConfig().setEnabled(true);
        config.getFooterConfig().setFontSize(8);
        config.getFooterConfig().setPageNumberFormat("— %d —");

        JQuickPdfFactory factory = new JQuickPdfFactory(config);
        factory.bindAll(data);
        byte[] pdf = factory.executeResource(TEMPLATE);
        Files.write(new File(OUT_FILE).toPath(), pdf);
        System.out.println("已生成：" + OUT_FILE + "（" + pdf.length + " 字节）");
    }

    /** 人民币金额转票据大写（元角分，末尾补「整」）。 */
    private static String toChineseAmount(BigDecimal amount) {
        String[] digits = {"零", "壹", "贰", "叁", "肆", "伍", "陆", "柒", "捌", "玖"};
        String[] units = {"", "拾", "佰", "仟"};
        String[] sections = {"", "万", "亿", "万亿"};
        long cents = amount.setScale(2, BigDecimal.ROUND_HALF_UP)
                .movePointRight(2).longValue();
        if (cents == 0) {
            return "零元整";
        }
        long yuan = cents / 100;
        int jiao = (int) (cents % 100 / 10);
        int fen = (int) (cents % 10);
        StringBuilder sb = new StringBuilder();
        if (yuan > 0) {
            sb.append(toChineseSection(yuan, digits, units, sections)).append("元");
        }
        if (jiao == 0 && fen == 0) {
            sb.append("整");
        } else {
            if (jiao > 0) {
                sb.append(digits[jiao]).append("角");
            } else if (yuan > 0) {
                sb.append("零");
            }
            if (fen > 0) {
                sb.append(digits[fen]).append("分");
            }
        }
        return sb.toString();
    }

    /** 整数部分按四位分节转大写。 */
    private static String toChineseSection(long value, String[] digits, String[] units, String[] sections) {
        StringBuilder sb = new StringBuilder();
        int sectionIndex = 0;
        boolean needZero = false;
        while (value > 0) {
            int section = (int) (value % 10000);
            StringBuilder part = new StringBuilder();
            int unitIndex = 0;
            boolean zeroInSection = false;
            int temp = section;
            while (temp > 0) {
                int digit = temp % 10;
                if (digit == 0) {
                    zeroInSection = true;
                } else {
                    if (zeroInSection || (needZero && part.length() == 0 && sb.length() > 0)) {
                        part.insert(0, digits[0]);
                    }
                    part.insert(0, units[unitIndex]);
                    part.insert(0, digits[digit]);
                    zeroInSection = false;
                    needZero = false;
                }
                unitIndex++;
                temp /= 10;
            }
            if (part.length() > 0) {
                part.append(sections[sectionIndex]);
            }
            sb.insert(0, part);
            needZero = section < 1000 && section > 0;
            value /= 10000;
            sectionIndex++;
        }
        return sb.toString();
    }
}

Minimal invocation (3 lines)

Skip the full test class — the core is these three lines: bind the chart SVG, execute the template, get the PDF bytes. Copy them straight into your project.

// config 可省略；svg 来自 JChartRendererFactory.renderChart(...)，见下方完整源码
byte[] pdf = new JQuickPdfFactory(config).executeResource("demo/biz/bank/151_audit_working_paper.txt");

Template file · 151_audit_working_paper.txt

An HTML-like template with inline CSS that renders to PDF once bound to data. The full template is below — copy it or download the raw file.

<pdf>
<body>
  // 151 金融审计工作底稿 / 函证回执单（bank 领域第 12 项）　视觉主题：绛紫·素雅·下线
  // 版式组合：抬头=underline 信息区=kv 明细表=light 段落=box 签章=right 落款=table
  // 主色 #4D246B　辅色 #869127　浅底 #F4F1F6
  // 金融审计工作底稿与函证回执单：账面金额、回函金额、差异与审计结论。

  // 抬头：underline
  <table style="width:100%; marginBottom:1px">
    <tr>
      <td style="width:62%; padding:2px; bold:true; fontSize:15pt; color:#300F48; characterSpacing:3pt">'金融审计工作底稿 / 函证回执单'</td>
      <td style="padding:2px; textAlign:right; fontSize:7.5pt; color:#78838C">'底稿索引 '${indexNo}'　　编制日期 '${prepareDate}'　　审计机构 '${firmName}</td>
    </tr>
  </table>
  <lineSeparator style="color:#4D246B; thickness:2.5f; marginBottom:8px"></lineSeparator>

  // 信息区：kv
  <table style="width:100%; fontSize:9pt; marginBottom:8px">
    <tr>
      <td style="width:22%; padding:5px; backgroundColor:#F4F1F6; bold:true; border:1px solid #CCC1D5">'底稿索引 / INDEX'</td>
      <td style="padding:5px; border:1px solid #CCC1D5">${indexNo}</td>
    </tr>
    <tr>
      <td style="width:22%; padding:5px; backgroundColor:#F4F1F6; bold:true; border:1px solid #CCC1D5">'编制日期 / DATE'</td>
      <td style="padding:5px; border:1px solid #CCC1D5">${prepareDate}</td>
    </tr>
    <tr>
      <td style="width:22%; padding:5px; backgroundColor:#F4F1F6; bold:true; border:1px solid #CCC1D5">'审计机构'</td>
      <td style="padding:5px; border:1px solid #CCC1D5">${firmName}</td>
    </tr>
    <tr>
      <td style="width:22%; padding:5px; backgroundColor:#F4F1F6; bold:true; border:1px solid #CCC1D5">'被审计单位'</td>
      <td style="padding:5px; border:1px solid #CCC1D5">${companyName}</td>
    </tr>
    <tr>
      <td style="width:22%; padding:5px; backgroundColor:#F4F1F6; bold:true; border:1px solid #CCC1D5">'审计期间'</td>
      <td style="padding:5px; border:1px solid #CCC1D5">${auditPeriod}</td>
    </tr>
    <tr>
      <td style="width:22%; padding:5px; backgroundColor:#F4F1F6; bold:true; border:1px solid #CCC1D5">'审计项目'</td>
      <td style="padding:5px; border:1px solid #CCC1D5">${auditItem}</td>
    </tr>
    <tr>
      <td style="width:22%; padding:5px; backgroundColor:#F4F1F6; bold:true; border:1px solid #CCC1D5">'函证编号'</td>
      <td style="padding:5px; border:1px solid #CCC1D5">${confirmNo}</td>
    </tr>
    <tr>
      <td style="width:22%; padding:5px; backgroundColor:#F4F1F6; bold:true; border:1px solid #CCC1D5">'被函证单位'</td>
      <td style="padding:5px; border:1px solid #CCC1D5">${confirmee}</td>
    </tr>
    <tr>
      <td style="width:22%; padding:5px; backgroundColor:#F4F1F6; bold:true; border:1px solid #CCC1D5">'编制人 / 复核人'</td>
      <td style="padding:5px; border:1px solid #CCC1D5">${preparerInfo}</td>
    </tr>
    <tr>
      <td style="width:22%; padding:5px; backgroundColor:#F4F1F6; bold:true; border:1px solid #CCC1D5">'底稿页数'</td>
      <td style="padding:5px; border:1px solid #CCC1D5">${pageInfo}</td>
    </tr>
  </table>

  <table style="width:100%; marginBottom:3px">
    <tr>
      <td style="padding:4px; backgroundColor:#F4F1F6; bold:true; fontSize:10pt; color:#300F48">'函证项目明细'</td>
    </tr>
  </table>
  <table style="width:100%; fontSize:8.5pt; marginBottom:8px">
    <tr>
      <th style="width:7%; padding:4px; backgroundColor:#F4F1F6; color:#300F48; bold:true; textAlign:center; border:1px solid #CCC1D5">'序号'</th>
      <th style="width:20%; padding:4px; backgroundColor:#F4F1F6; color:#300F48; bold:true; textAlign:center; border:1px solid #CCC1D5">'函证项目'</th>
      <th style="width:16%; padding:4px; backgroundColor:#F4F1F6; color:#300F48; bold:true; textAlign:center; border:1px solid #CCC1D5">'账面金额'</th>
      <th style="width:16%; padding:4px; backgroundColor:#F4F1F6; color:#300F48; bold:true; textAlign:center; border:1px solid #CCC1D5">'回函金额'</th>
      <th style="width:14%; padding:4px; backgroundColor:#F4F1F6; color:#300F48; bold:true; textAlign:center; border:1px solid #CCC1D5">'差异'</th>
      <th style="width:13%; padding:4px; backgroundColor:#F4F1F6; color:#300F48; bold:true; textAlign:center; border:1px solid #CCC1D5">'回函方式'</th>
      <th style="padding:4px; backgroundColor:#F4F1F6; color:#300F48; bold:true; textAlign:center; border:1px solid #CCC1D5">'结论'</th>
    </tr>
    <tr>
      <td style="padding:4px; textAlign:center; border:1px solid #E2DFE5">${itemName1}</td>
      <td style="padding:4px; textAlign:left; border:1px solid #E2DFE5">${itemSpec1}</td>
      <td style="padding:4px; textAlign:right; border:1px solid #E2DFE5">${itemUnit1}</td>
      <td style="padding:4px; textAlign:right; border:1px solid #E2DFE5">${itemQty1}</td>
      <td style="padding:4px; textAlign:right; border:1px solid #E2DFE5">${itemPrice1}</td>
      <td style="padding:4px; textAlign:center; border:1px solid #E2DFE5">${itemAmount1}</td>
      <td style="padding:4px; textAlign:center; border:1px solid #E2DFE5">${itemTax1}</td>
    </tr>
    <tr>
      <td style="padding:4px; textAlign:center; border:1px solid #E2DFE5">${itemName2}</td>
      <td style="padding:4px; textAlign:left; border:1px solid #E2DFE5">${itemSpec2}</td>
      <td style="padding:4px; textAlign:right; border:1px solid #E2DFE5">${itemUnit2}</td>
      <td style="padding:4px; textAlign:right; border:1px solid #E2DFE5">${itemQty2}</td>
      <td style="padding:4px; textAlign:right; border:1px solid #E2DFE5">${itemPrice2}</td>
      <td style="padding:4px; textAlign:center; border:1px solid #E2DFE5">${itemAmount2}</td>
      <td style="padding:4px; textAlign:center; border:1px solid #E2DFE5">${itemTax2}</td>
    </tr>
    <tr>
      <td style="padding:4px; textAlign:center; border:1px solid #E2DFE5">${itemName3}</td>
      <td style="padding:4px; textAlign:left; border:1px solid #E2DFE5">${itemSpec3}</td>
      <td style="padding:4px; textAlign:right; border:1px solid #E2DFE5">${itemUnit3}</td>
      <td style="padding:4px; textAlign:right; border:1px solid #E2DFE5">${itemQty3}</td>
      <td style="padding:4px; textAlign:right; border:1px solid #E2DFE5">${itemPrice3}</td>
      <td style="padding:4px; textAlign:center; border:1px solid #E2DFE5">${itemAmount3}</td>
      <td style="padding:4px; textAlign:center; border:1px solid #E2DFE5">${itemTax3}</td>
    </tr>
    <tr>
      <td style="padding:4px; textAlign:center; border:1px solid #E2DFE5">${itemName4}</td>
      <td style="padding:4px; textAlign:left; border:1px solid #E2DFE5">${itemSpec4}</td>
      <td style="padding:4px; textAlign:right; border:1px solid #E2DFE5">${itemUnit4}</td>
      <td style="padding:4px; textAlign:right; border:1px solid #E2DFE5">${itemQty4}</td>
      <td style="padding:4px; textAlign:right; border:1px solid #E2DFE5">${itemPrice4}</td>
      <td style="padding:4px; textAlign:center; border:1px solid #E2DFE5">${itemAmount4}</td>
      <td style="padding:4px; textAlign:center; border:1px solid #E2DFE5">${itemTax4}</td>
    </tr>
    <tr>
      <td style="padding:4px; textAlign:center; border:1px solid #E2DFE5">${itemName5}</td>
      <td style="padding:4px; textAlign:left; border:1px solid #E2DFE5">${itemSpec5}</td>
      <td style="padding:4px; textAlign:right; border:1px solid #E2DFE5">${itemUnit5}</td>
      <td style="padding:4px; textAlign:right; border:1px solid #E2DFE5">${itemQty5}</td>
      <td style="padding:4px; textAlign:right; border:1px solid #E2DFE5">${itemPrice5}</td>
      <td style="padding:4px; textAlign:center; border:1px solid #E2DFE5">${itemAmount5}</td>
      <td style="padding:4px; textAlign:center; border:1px solid #E2DFE5">${itemTax5}</td>
    </tr>
    <tr>
      <td style="padding:4px; textAlign:center; border:1px solid #E2DFE5">${itemName6}</td>
      <td style="padding:4px; textAlign:left; border:1px solid #E2DFE5">${itemSpec6}</td>
      <td style="padding:4px; textAlign:right; border:1px solid #E2DFE5">${itemUnit6}</td>
      <td style="padding:4px; textAlign:right; border:1px solid #E2DFE5">${itemQty6}</td>
      <td style="padding:4px; textAlign:right; border:1px solid #E2DFE5">${itemPrice6}</td>
      <td style="padding:4px; textAlign:center; border:1px solid #E2DFE5">${itemAmount6}</td>
      <td style="padding:4px; textAlign:center; border:1px solid #E2DFE5">${itemTax6}</td>
    </tr>
    <tr>
      <td style="padding:4px; bold:true; backgroundColor:#F4F1F6; textAlign:center; border:1px solid #4D246B">'函证金额合计'</td>
      <td style="padding:4px; backgroundColor:#F4F1F6; border:1px solid #4D246B">'—'</td>
      <td style="padding:4px; bold:true; backgroundColor:#F4F1F6; textAlign:right; border:1px solid #4D246B">'￥'${totalAmount}</td>
      <td style="padding:4px; bold:true; backgroundColor:#F4F1F6; textAlign:right; border:1px solid #4D246B">'￥'${confirmTotal}</td>
      <td style="padding:4px; backgroundColor:#F4F1F6; border:1px solid #4D246B">'—'</td>
      <td style="padding:4px; backgroundColor:#F4F1F6; border:1px solid #4D246B">'—'</td>
      <td style="padding:4px; backgroundColor:#F4F1F6; border:1px solid #4D246B">'—'</td>
    </tr>
  </table>

  // 段落：box
  <table style="width:100%; marginBottom:6px">
    <tr>
      <td style="width:150px; padding:5px; backgroundColor:#F4F1F6; bold:true; fontSize:9.5pt; color:#300F48; border:1px solid #CCC1D5">'账面金额合计'</td>
      <td style="padding:5px; fontSize:9pt; border:1px solid #CCC1D5">${totalLine}</td>
    </tr>
  </table>
  <table style="width:100%; marginBottom:6px">
    <tr>
      <td style="width:150px; padding:5px; backgroundColor:#F4F1F6; bold:true; fontSize:9.5pt; color:#300F48; border:1px solid #CCC1D5">'审计结论'</td>
      <td style="padding:5px; fontSize:9pt; border:1px solid #CCC1D5">${conclusion}</td>
    </tr>
  </table>

  // 签章区：right
  <!-- 签章占位区：后续加盖电子公章 / 骑缝章 / 打印二维码 -->
  <table style="width:100%; fontSize:8pt; marginBottom:8px">
    <tr>
      <td style="width:32%; padding:5px; backgroundColor:#F4F1F6; fontSize:7.5pt; color:#78838C; border:1px solid #CCC1D5">'本联次加盖印章后有效，扫码可验真'</td>
      <td style="padding:3px; textAlign:center; color:#4D246B; border:1px dashed #4D246B">'（银行业务章 / 公章占位）'　'（骑缝章 / 二维码占位）'</td>
    </tr>
    <tr>
      <td style="width:32%%; padding:4px">' '</td>
      <td style="padding:3px; textAlign:center; color:#78838C; border:1px dashed #4D246B">'机构名称：'${firmName}　'骑缝章沿右边线骑缝加盖'</td>
    </tr>
    <tr>
      <td style="width:32%%; padding:4px">' '</td>
      <td style="padding:3px; textAlign:center; color:#78838C; border:1px dashed #4D246B">'业务日期：'${prepareDate}　'二维码打印于右上角方框内'</td>
    </tr>
  </table>

  // 落款：table
  <!-- 落款栏 -->
  <table style="width:100%; fontSize:8.5pt">
    <tr>
      <td style="width:33%; padding:5px; border:1px solid #CCC1D5">'编制人：'${preparer}</td>
      <td style="width:33%; padding:5px; border:1px solid #CCC1D5">'复核人：'${reviewer}</td>
      <td style="padding:5px; border:1px solid #CCC1D5">'被函证单位签章：'${confirmeeSign}</td>
    </tr>
  </table>
</body>
</pdf>

More demos in this group

The PDF, preview image, template and source code on this page were all produced by a real JQuick-Pdf run and are free to copy into your own project.